Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6, Problem 2RQ
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
Trending nowThis is a popular solution!
Students have asked these similar questions
Exactly how many global descriptor tables are there?
what is Child table ?
What exactly is a Parent table?
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
- How many local descriptor tables can exist?arrow_forwardWhy are some table structures considered to be bad and others good?How do you recognize the difference between good and bad table structures?What effect does normalization have on creating good tables and why should you learn so many normalization rules?arrow_forwardwhat is Parent table ?arrow_forward
- 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_forwardWhat are tables and Fields?arrow_forwardWhat does it mean to be transitive? Tables in the second normal form can be converted to tables in the third normal form, but what is the rule for doing so?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you