Your cart is empty!
A. Construct a normalized model to represent the donut shop smartphone application database that supports the scenario above by doing the following:
1. Using the attached “Sales Order Form” (unnormalized order form) for the donut ordering database as a reference, produce the final logical schema for this database by doing the following:
Note: You can design the tables for the following prompts using any method of your choice (e.g., using a drawing tool using tables).
a. Design one table that is in first normal form and fulfills the following requirements:
• The table should have a primary key that uniquely identifies the records.
• The values in each of the columns should be atomic.
• There should be no repeating groups.
• Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and Total) in your normalization diagrams.
i.
Explain how you designed the table (suggested length of 1 paragraph).
b. Design three tables that are in second normal form and fulfill the following requirements:
• The tables should meet all of the requirements for the first normal form.
• All functional dependencies should be removed from the tables.
• Each of the tables should have all primary and/or foreign keys designated.
• Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and Total) in your normalization diagrams.
i. Explain how you designed the tables (suggested length of 1 paragraph).
Please Sign In to contact this author.