"Normalization and Redundancy"

Computer Science
Tutor: None Selected Time limit: 1 Day

Identify the key determinants that could affect the degree of normalization of a database. In your own words

Jul 26th, 2015

Thank you for the opportunity to help you with your question!

Basically, normalization is the process of efficiently organizing data in a database. There are two main objectives of the normalization process: eliminate redundant data (storing the same data in more than one table) and ensure data dependencies make sense (only storing related data in a table). Both of these are valuable goals as they reduce the amount of space a database consumes and ensure that data is logically stored.

Most of these problems are the result of two bad design features called: redundant data and anomalies. Redundant data is unnecessary reoccurring data (repeating groups of data). Anomalies are any occurrence that weakens the integrity of your data due to irregular or inconsistent storage (delete, insert and update irregularity, that generates the inconsistent data).


Please let me know if you need any clarification. I'm always happy to answer your questions.
Jul 26th, 2015

Are you studying on the go? Check out our FREE app and post questions on the fly!
Download on the
App Store
...
Jul 26th, 2015
...
Jul 26th, 2015
Dec 6th, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer