2 Answers - Sort by: Date | Rating
A database which is not normalized would have relations of the same data. This means that to update the database you would need to update the same data in several different places. This would tend to slow down the database access and make it larger than it needs to be.
0
0
That was a very common answer with a practical point of view eliminate redundancy in other words.
Other more technical answer is that Relational Algebra is equivalent to Predicate Calculus (with closed world assumption and other details not to talk about them now).
Normalization is needed because it is equivalent to quantification in Predicate Calculus.
It is not the same to say: For all boys thee exists one girl they are married with than one girl is married with all boys (polyandry)
quantifiers for all, exist, exist just one, are very subtle to use. If done careless many mistakes may occur, also with its counterpart in relational algebra, normalization.
In synthesis: If you do not normalize your database will not represent the world you want to.
Other more technical answer is that Relational Algebra is equivalent to Predicate Calculus (with closed world assumption and other details not to talk about them now).
Normalization is needed because it is equivalent to quantification in Predicate Calculus.
It is not the same to say: For all boys thee exists one girl they are married with than one girl is married with all boys (polyandry)
quantifiers for all, exist, exist just one, are very subtle to use. If done careless many mistakes may occur, also with its counterpart in relational algebra, normalization.
In synthesis: If you do not normalize your database will not represent the world you want to.
0
1
Guest
answered 8 months ago
- How To Draw Normalization?
- What Is The Advantages Of Paper-based Communication?
- What Is A Flat File?
- What Is Data Integrity Problems?
- What Are The Accessing Methods?
- How Does A Model Look The Way She Does?
- Define Demerits Of Conventional File System?
- How Candidate Key Is Differ From Concatenated Key?
- Is Relational Model Logically Independent?
- Discuss The Relative Advantage Of Centralized And Distributed Databases?
- What Does Cdr/cdt Transaction Mean?
- How Do Accountants Use Databases?
- What Is The Database Component In Database Application?
- Define The Difference Between Logical And Physical Data Views?
- How Middleware Works Between Client And Server?
- What Is Table,cell,row And Columns In MS Word?
- What Are Some Errors In Using Database?
- An Sql Server Is Not An Operating System... why Are People Always Asking Exam Questions On This Site?
- What Is 4nf?
- What Is Hierarchical Communication?
- Q. How Many Types Of Anomalies Are There In A RDBMS?
- What Is Entity Integrity?
- What Is Integrity Constraints?
- What Is A Referential Anomaly?
- When Did Uganda Get Its Independence?
- What Is A Relational Database?
- What Do You Know About Relational Database Systems?
- What Is Relational Database Environment ?
- What Is A Relational Database Schema?
- Describe Relational Database Type, Can You Help?
- What Is Relational Database Management System?
- What Is The Difference Between A Network Database And A Relational Database?
- What's The Difference Between Relation Schema And Relational Database Schema?

New Comment - Comments are editable for 5 min.