The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.
Your database project must meet the following assessment requirements:
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).
Use 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.
Submit the ERD and final database to the appropriate Assignment link.
Click the Assignment Files tab to submit your assignment.