Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL For Data Science Data Cleaning Wrangling And Analytics With Relational Databases

Authors: Antonio Badia

1st Edition

3030575918, 978-3030575915

More Books

Students also viewed these Databases questions