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.

…….

Leave a Reply

Your email address will not be published. Required fields are marked *

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.

…….

Leave a Reply

Your email address will not be published. Required fields are marked *