DBM/380 Week 4 Individual: Normalization of the ERD

profileRSaleem
 (Not rated)
 (Not rated)
Chat

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).


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.


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

    • 9 years ago
    DBM/380 Week 4 Individual: Normalization of the ERD - Plagiarism Free
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      week_4.vsd
    • attachment
      mantech_1.accdb