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

Contact the Author

Please Sign In to contact this author.