Create a Crow’s Foot Notation Entity Relationship Diagram (ERD) to support the following business operations: An online
Posted: Fri Jul 01, 2022 5:52 am
Create a Crow’s Foot Notation Entity Relationship Diagram (ERD)to support the following business operations: An online foodordering system wants to keep track of their customers, orders,food items, and employee details in order to streamline theiradministration and operational tasks.
The company has wisely chosen to hire you as a databasedesigner. You are required to design the data model for the newdatabase called “FoodOnline” that satisfies the constraints anduser view requirements given below. User view 1 requirement:Restaurant has employees, each identified by a unique employeenumber, first name, last name, address, and phone. User view 2requirements: Customer visits the restaurant, online and placeorders. First, customer should register by entering theircredentials (email, name, phone, address, and password).
Then, they order by specifying the food codes in the menu andquantity of the food required. User view 3 requirements: For eachorder, order_ID, customer_ID, Total_price, Total_items, and datewill be recoded. The restaurant maintains a staff roster to ensurethat there are sufficient staff in the shift. The system allocatesone employee per order. Those employees who are working in therestaurant are assigned to zero or more orders. User view 4requirements: Each order contains specified quantities of one ormore food items. Every food item may appear zero or more times inan order table. User view 5 requirements: For each food itempresented in the online menus is identified by a unique food_code,a food name, and price. User view 6 requirements: Customer paymentdetails will be recoded in Payment table with the followinginformation: Payment_ID, order_ID, customer_ID, and Total_payment.User view 7 requirements: Once the payment is completed and theorder is ready to deliver, delivery will be organised. Registereddrivers may or may not have a delivery assigned, and they may havemore than one delivery order
a) Identify 4 business rules describing the relationshipsbetween entities and write the type of relationship, as givenbelow, based on the description of operations given in thequestion. Example: One customer can place one or more orders:One–to-many relationship. [2 Marks]
b) Identify entities, attributes, and primary keys thatadequately describe the entities. Construct them as a collection ofTables (e.g. given below). You are required to indicate primarykeys (underline). E.g. Customer (Cust_ID, firstname, lastname, age)[3 Marks]
c) Determine the functional dependencies (FD). Normalise theserelations to 3rd normal form, ensuring that the resulting relationsare dependency-preserving. You need to explain each step clearly.Eg. Cust_ID firstname, lastname, age, ..., ... [5 Marks]
d) ER diagram a. Represent the structure of your databasevisually by using an entity-relationship (ER) diagram. You arerequired to: i. Draw the ER diagram on paper (do not use anysoftware tools) and include the image in your Word document. ii.Name all entities in the ER diagram including your name. Forexample: If you have Entity name Student, you will name it as“Yourname:Student”. If “Sam Smith” is drawing the ER diagram hewill name the “Student” entity as “Sam_Smith:Student”. iii. If youmake any assumptions about data that are not explicitly given inthe problem, these must be described. [20 Marks]
NB: This should be your own individual work. If not, it isconsidered cheating and you will get zero marks for the wholeexam
this questions is completely one questions and attach thescreenshot of output please its urgent please dont copy past anddont write on handwrite
The company has wisely chosen to hire you as a databasedesigner. You are required to design the data model for the newdatabase called “FoodOnline” that satisfies the constraints anduser view requirements given below. User view 1 requirement:Restaurant has employees, each identified by a unique employeenumber, first name, last name, address, and phone. User view 2requirements: Customer visits the restaurant, online and placeorders. First, customer should register by entering theircredentials (email, name, phone, address, and password).
Then, they order by specifying the food codes in the menu andquantity of the food required. User view 3 requirements: For eachorder, order_ID, customer_ID, Total_price, Total_items, and datewill be recoded. The restaurant maintains a staff roster to ensurethat there are sufficient staff in the shift. The system allocatesone employee per order. Those employees who are working in therestaurant are assigned to zero or more orders. User view 4requirements: Each order contains specified quantities of one ormore food items. Every food item may appear zero or more times inan order table. User view 5 requirements: For each food itempresented in the online menus is identified by a unique food_code,a food name, and price. User view 6 requirements: Customer paymentdetails will be recoded in Payment table with the followinginformation: Payment_ID, order_ID, customer_ID, and Total_payment.User view 7 requirements: Once the payment is completed and theorder is ready to deliver, delivery will be organised. Registereddrivers may or may not have a delivery assigned, and they may havemore than one delivery order
a) Identify 4 business rules describing the relationshipsbetween entities and write the type of relationship, as givenbelow, based on the description of operations given in thequestion. Example: One customer can place one or more orders:One–to-many relationship. [2 Marks]
b) Identify entities, attributes, and primary keys thatadequately describe the entities. Construct them as a collection ofTables (e.g. given below). You are required to indicate primarykeys (underline). E.g. Customer (Cust_ID, firstname, lastname, age)[3 Marks]
c) Determine the functional dependencies (FD). Normalise theserelations to 3rd normal form, ensuring that the resulting relationsare dependency-preserving. You need to explain each step clearly.Eg. Cust_ID firstname, lastname, age, ..., ... [5 Marks]
d) ER diagram a. Represent the structure of your databasevisually by using an entity-relationship (ER) diagram. You arerequired to: i. Draw the ER diagram on paper (do not use anysoftware tools) and include the image in your Word document. ii.Name all entities in the ER diagram including your name. Forexample: If you have Entity name Student, you will name it as“Yourname:Student”. If “Sam Smith” is drawing the ER diagram hewill name the “Student” entity as “Sam_Smith:Student”. iii. If youmake any assumptions about data that are not explicitly given inthe problem, these must be described. [20 Marks]
NB: This should be your own individual work. If not, it isconsidered cheating and you will get zero marks for the wholeexam
this questions is completely one questions and attach thescreenshot of output please its urgent please dont copy past anddont write on handwrite