3/2/2016 12:12:51 AM
The assignment is all about models, databases, tables and query reports. Construct a normalized model to symbolize the donut shop Smartphone application database which supports the scenario above by performing the following:
1) Design a table which is in first normal form and fulfills the given:
a) The table must encompass a primary key which uniquely recognizes records.
b) The values in each of columns must be atomic.
2) Design at least two tables which are in second normal form and perform the given:
a) The tables must meet up all requirements for the first normal form.
b) Redundant data appearing in multiple rows must be removed by the creation of the new tables.
c) Each of tables must be associated by using foreign keys.
3) Design at least three normalized tables which are in third normal form and perform the given:
a) The tables must meet up all the requirements for the first and second normal forms.