Chidi's Hub: The Computing Blog

(Freepik, 2020) Bis cobing defines Entity Relationship Diagram (ERD) as "a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system. An ERD uses data modeling techniques that can help define business processes and serve as the foundation for a relational database." ( Biscobing, 2019) The ERD comprises of certain terminologies used in relation to the items on the diagram. These are: Entity "An entity may be any object, class, person or place. In the ER diagram, an entity can be represented as rectangles.  Consider an organization as an example- manager, product, employee, department etc. can be taken as an entity." (Javapoint, no date) Attribute "The attribute is used to describe the property of an entity. Eclipse is used to represent an attribute. For example, id, age, contact number, name, etc. can be attributes of a student." (Javapoint, no date) Relationship The re...

(Rawpixel, 2021) According to Oracle, a database is a well-organized assortment of structured information or data, which is often stored digitally in a computer system. To manage the data, a database management system (DBMS) is usually employed. The combination of the data, the DBMS, and the associated applications is referred to as a database system or simply a database. ( Oracle, no date) It ensures that the user can perform the following tasks: Create Read Update; and Delete Most databases today are designed using tables with rows and columns to enable efficient processing and data querying. The data can be easily accessed, manipulated, updated, controlled, and arranged using a DBMS. Structured Query Language (SQL) is the most widely used language for writing and querying data in databases. ( Oracle, no date)   Examples of Databases Below are some examples of Databases Microsoft SQL Server "SQL Server, developed by Microsoft, is a Relational Database Management System. It is bu...

Storyset (2019) As a prerequisite for this module, I had to create a customer database. In the creation of this data base I had to create fields for "Customer ID/Number", "Customer Name", "Last name", "Phone number" and "Post code". I will be highlighting the processes I took in creating the customer database. The first step I took was to create the field headings, as listed in the introduction paragraph above. After crating these headings, I filled them with randomized values for the names, phone numbers, and postal codes. The table was beginning to look substantial. Finally, I formatted the data as a table. MS-Excel automatically created a bold border around the table, with the headings on it, as dropdowns. I added thinner lines between each column to make the values more distinguishable. Having done this, I saved my progress and stored it as my customer database file. Product Database Similar to the customer database, I also created ...

(Katemangostar, 2023) Software development comprises of various intricate procedures, which when carried out effectively, produce good results. This blog post aims at enumerating these steps, and explaining software development. "The Software Development Life Cycle (SDLC) refers to a methodology with clearly defined processes for creating high-quality software." (Altvater, 2023) According to Altvater, Software Development Life Cycle or SDLC is the process that produces the best quality software, with minimal costs, in the shortest possible time. (Altvater, 2023) There are six main SDLC methodologies, viz:  Agile Lean Waterfall Iterative Spiral DevOps    (Clouddefence, 2023) According to Robert Half, this SDLC model is the Spiral methodology. It provides an organized flow of steps which aid the firm or organization to produce good quality software in no time, which goes through testing and is soon ready for production use. (Half, 2023) These key steps include: Planning: T...

Rawpixel (2018) I have selected the Reverb and Sweetwater product pages as case studies for my comparison in this blog. Sweetwater Sweetwater (2023) Opening the product page of the Sweetwater website, one is greeted immediately with a large banner occupying the entire screen. While this may serve a reason to the developers of this website, it does come off as obstructive and an ineffective use of space. The customer (myself, for example) is not immediately met with the products that make up the product page. Sweetwater (2023) The products are distinctly split up into categories, as seen at the left side of the picture above. However, pricing and details of the location and promotional offers of the product are not immediately seen. This would affect customers who purchase with price as a determining factor. It does not reveal the complete or sufficient details of the product on the product page at a glance, and will thus, impede or affect the user experience of the customer. Reverb Rev...

(Freepik, 2014) As stated in this e-commerce module, the 4Ps of marketing are, "Price", "Promotion", "Product", and "Place". This blog post aims not only to explain these marketing principles, but also to explain how these 4Ps have been incorporated into the development of my e-commerce website. Product The key questions to be answered by any marketer, about the products are: "Who needs it, and why? What does it do that no competitor's product can do?"  (Twin, 2022) "The job of the marketer is to define the product and its qualities and introduce it to the consumer." (Twin, 2022) fig: 1.1 As a case study, I have taken a screenshot of a product in my e-commerce website. The page above not only describes the color and brand, but also describes the product to customers. Price Another crucial aspect is the price of the commodity. It is important that the marketer determines how much a product is worth, and how much customers s...