Normalization

 

Week 4.   Discussion                                              

 

Normalization

 

 

 

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

 

 

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

 

 

  3  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?

 

 

 

 

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

 

            What is normalization?

 

 

 

5. Write 200- to 300-word short-answer response to the following:

 

What is a surrogate key, and when should you use one?

 

 

 

6. Write 200- to 300-word short-answer response to the following:

 

Define and discuss the concept of transitive dependency.

 

 

 

7. Write 200- to 300-word short-answer response to the following:

 

What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated?

 

            8. Write 200- to 300-word short-answer response to the following:

 

How would you describe a condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?

 

 

 

APA format requires a concluding paragraph which sums up the wholepaper.     

 

                                                           

 

Format your paper consistent with APA guidelines.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

Format your paper consistent with APA guidelines

 

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order