Design
and develop a database using professional principles and standards.
Provide a logical and physical design of the database.
Use relational database software application to develop database.
Provide an entity relationship diagram.
Normalize the database.
Generate and provide test data.
Use
a Microsoft
®
Visio
®
diagram to normalize the ERD to third normal form (3NF).
Us
e
the Microsoft
®
Access
®
database created in Week Three to create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables.
Note
. Only the Microsoft
®
Visio
®
diagram must be normalized to the 3NF. The 3NF is not required for a Microsoft
®
Access
®
database.