Question

In a minimum of 100 words in your own words, discuss what database normalization means and...

In a minimum of 100 words in your own words, discuss what database normalization means and the goals for normalization.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Data base normalization and Its goals

Database normalization is basically the process of making the data structure free from data redundancy and with high data integrity with the help of normal forms.

Normalization involves the columns and tables of the data base to be organized to ensure that their data dependencies are properly enforced by database integrity constraints. This can be done with the help of creating a new database design or improving the existing database design.

The objectives or goals for database normalization are as follows:

1- it makes the relational model of database more informative for the end users.

2-It also reduces the requirement of restructuring the collection of relations whenever new data types are introduced which increases the life span of applications.

3-It makes the database collection free from undesirable insertion, deletion or updation.

4-Also it makes the collection of relations neutral to query statistics.

if you like the answer please provide a thumbs up.

Add a comment
Know the answer?
Add Answer to:
In a minimum of 100 words in your own words, discuss what database normalization means and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT