week 4 DBM 100% (((ORIGANAL WORK WITH CITATIONS AND REFRENCES)) NO MORE THAN 5%PLAGERISM

Supporting Activity

Normalization Process

Write a 200- to 300-word short-answer response for the following:

 In your own words, describe the nature and purpose of the normalization process. Provide some examples from sources other than the readings.

1

Supporting Activity

Disadvantage of Normalizing

Write a 200- to 300-word short-answer response for the following:

 Discuss the disadvantages of normalizing a database to a high degree of normalization. Should there be a definite rule on when to stop normalizing? Provide some examples from sources other than the readings.

1

Supporting Activity

Denormalization

Write a 200- to 300-word short-answer response for the following:

 In what business database environments is denormalization appropriate and why? What would denormalization specifically involve?

1

Individual Normalization of

The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.

15

DBM/380 Version 9 10

the ERD

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