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.

DBM/380 Week 1 Individual: Database Design Paper

http://www.homeworkmarket.com/content/dbm380-week-1-individual-database-design-paper

DBM/380 Week 2 Individual: Database Environment Paper

http://www.homeworkmarket.com/content/dbm380-week-2-individual-database-environment-paper

DBM/380 Week 2 Learning Team: Service Request SR-ht-003: Change Request 2

http://www.homeworkmarket.com/content/dbm380-week-2-learning-team-service-request-sr-ht-003-change-request-2

DBM/380 Week 3 Individual: ERD Creation Project

http://www.homeworkmarket.com/content/dbm380-week-3-individual-erd-creation-project

DBM/380 Week 3 Learning Team: Service Request SR-ht-003: Change Request 3

http://www.homeworkmarket.com/content/dbm380-week-3-learning-team-service-request-sr-ht-003-change-request-3

DBM/380 Week 4 Individual: Normalization of the ERD

http://www.homeworkmarket.com/content/dbm380-week-4-individual-normalization-erd

DBM/380 Week 4 Learning Team: SR-ht-003: Change Request 4 and 5

http://www.homeworkmarket.com/content/dbm380-week-4-learning-team-sr-ht-003-change-request-4-and-5

DBM/380 Week 5 Learning Team: Service Request SR-ht-003

http://www.homeworkmarket.com/content/dbm380-week-5-learning-team-service-request-sr-ht-003

DBM/380 Week 5 Learning Team: Service Request SR-ht-003 Presentation

http://www.homeworkmarket.com/content/dbm380-week-5-learning-team-service-request-sr-ht-003-presentation

DBM/380 Week 5 Learning Team: Service Request SR-ht-003 Paper + Presentation

http://www.homeworkmarket.com/content/dbm380-week-5-learning-team-service-request-sr-ht-003-paper-presentation