Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6, Problem 3RQ
Program Plan Intro
Normalization:
The process used to minimize data redundancy and dependency in a relational
- The database table is divided into two or more tables and defines the relationship between those tables.
- If the modifications, deletion or updates occur in one table, the other tables in database get updated by just propagating it.
- In a relational database, the tables with no redundant data and less null values are considered as efficient table.
- This is because, having redundant data and more null values increases the storage space and wastage of memory is imminent.
- Null values cause a problem for data integrity and produces more error in the database.
- If the wasted storage space and null values which cause data integrity hazards are minimized, a highly optimized relational database can be designed.
- The project team should consider using normalization when designing the database, which is the best source to optimize data storage efficiently; this is because, it reduces the data storage space and provides data integrity.
- There are three types of normal forms.
- First normal form (1NF)
- Second normal form (2NF)
- Third normal form (3NF)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
What exactly is UML?
What are Inconsistent key structures?
How does DDL apply its definitions? Can I help?
Chapter 6 Solutions
Database Systems: Design, Implementation, & Management
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- can you provide me with details on the progression from 1NFÂ to 3NF form with the relation between the tables along with the EERÂ design? thank youarrow_forwardLook at the differences between the main key-based definitions of 2NF and 3NF and the more general ones. Give a particular example to support your argument.arrow_forwardA bridge/joint table is exactly what its name implies. What is the substitute? What is wrong with the substitute?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you