C-170 Data Management Application Performance Assessment.

C-170 Data Management Application Performance Assessment.

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).