During this stage, you will draft your entity-relationship diagram (ERD), addressing the following elements: A. Construct your ERD, utilizing your identified entities and attributes. B.
During this stage, you will draft your entity-relationship diagram (ERD), addressing the following elements:
A. Construct your ERD, utilizing your identified entities and attributes.
B. Determine appropriate primary and foreign keys for each entity and note them on your ERD.
C. Determine table relationships and note them on your ERD.
D. Determine appropriate data types and sizes for each attribute and note them on your ERD.
E. Complete the normalization process utilizing dependency diagrams in order to prove tables are in third normal form (3NF), and adjust your ERD if necessary. Hint: For each entity and table, complete dependency diagrams proving the table is in 3NF. If a table is in 3NF, only one diagram is needed; if it is not in 3NF, progress through the normalization process, breaking up tables as necessary. Additionally, revise your ERD based on the results of your normalization process.
Here is the data that needs to be categorized:
Pizza orders, including toppings added.
Customer who ordered pizza.
Address pizza was delivered to.
Name and phone number of employee who delivered pizza.
Name of employee who took pizza order.
Sales per hour, day, week, and month.
Delivery status details at various points in the night. Each order should have a status along with the order date and time and the delivery date and time. Note that if a customer picks up the pizza, the pickup time is the delivery time.
Some other considerations for the ordering process includethe following:
A customer can certainly order more than one pizza.
Customers move often and may order from different locations (a friends house ,for instance), so address details may also change often. However, each customer would have one prefe rred address.
Most orders need to be completed and delivered within an hour.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started