What can be done to effectively document the relational database system solution that you are proposing to the retail store?

What can be done to effectively document the relational database system solution that you are proposing to the retail store?
May 20, 2021 Comments Off on What can be done to effectively document the relational database system solution that you are proposing to the retail store? Uncategorized Assignment-help
Words: 490
Pages: 2
Subject: Uncategorized

Carrefour is a mega supermarket under the wholesale and retail industry. It provides retail services and a merchandize store for food and non-food items, households. It doubles as groceries store while also offering catering services to its current and future potential clients. Some of its vital merchandise products include canned juice, medicine, bakery products, vegetables, and fruits just to mention a few. The company has experienced tremendous growth over the past months. It has opened both physical and online retail stores. An analysis of the database indicates that many customers have expressed their interest and goodwill to make purchases from the retail store electronically. It has simple websites but there are some ambiguities whether the platform can support dynamic interactions and online purchases compared to the physical stores facing some challenges. Database Goals and Objectives The goal of the firm is to increase the customers’ or users’ experience (UX) by creating a database with a better user interface (UI). The database is aimed at expanding the business opportunities for the firm through the online retail system by availing necessary information regarding retail products and customer care inquiries. In addition, it has the goal of increasing its sales value by double digits and expanding further to the emerging markets The assignment : The retail store has provided you with a list of some of the business rules that they use to conduct business on a daily basis. The company has also provided you with the subjects of interest to them, namely those things that the company wants to track in the process of taking orders from their customers. What can be done to effectively document the relational database system solution that you are proposing to the retail store? Click here to see worked examples. Assignment work : The project deliverables are as follows: •Subjects of Interest (proposed entities) oCustomers oOrders oProducts oAdd a minimum of 3 of more subjects of interest based on your retail store. •Business Rules oEach product is assigned to a maximum of 1 category. oA person who has placed at least 1 order is a customer. oAll products have a minimum reorder level. oAdd a minimum of 3 of more business rules based on your retail store. •Entity–Relationship Model oInclude a list of the business rules that will be enforced by the proposed database system. oInclude a list or table of the entities, attributes (including data types), relationships, and cardinality constraints. oInclude an entity–relationship (E–R) diagram that uses crow’s foot notation and graphically depicts the entities, attributes (including data types), and relationships (including degree and cardinality constraints). oVerify that the data design that is depicted in the E–R diagram adheres to a minimum of third normal form (3NF), and if necessary, provide documentation and justification for the use of a higher level of normal form. •Provide your analysis as to how this part of the project fulfills the mission and 1 or more goals of the case study organization.