Database - The Relational Model and Normalization - Discussion
Discussion Forum : The Relational Model and Normalization - General Questions (Q.No. 2)
2.
The different classes of relations created by the technique for preventing modification anomalies are called:
Discussion:
15 comments Page 1 of 2.
Loga priya said:
1 decade ago
The relation should be consistent enough to retrive the correct data. So normal forms have to be used for making the db free from anomalies.
Shafeeq said:
1 decade ago
The Normal form help to remove the dependencies between the data. So, that the there is only one primary key for each table.
Suman pandit said:
1 decade ago
Because by normal form we actually try to create such type of relation schema where the relation schema has a distinct primary key and the other non key attributes are fully functionally dependent on the primary key.
Raku said:
1 decade ago
BY using narmal form we remove duplication attributes of table.
Nanda said:
1 decade ago
By normalization the redundancy of the database data is reduced.
Manish choudhary said:
1 decade ago
Normal form used for remove the independence for data in the relation and normal form remove the duplication attribute from table.
Ansar said:
1 decade ago
What about referential integrity constraints. Constraints are set of rules for deciding what data is going to be stored into the database or retrieve from the database. So while considering that point I think constraints can be used to prevent modification.
Suchismita said:
1 decade ago
Normalisation is a technique which is used to design the best DATA BASE. It arranges the Data in the database in such a way that each database is redundant free, anomaly free & achieved data independence using different normal forms.
Different normal forms are 1nf, 2nf, 3nf & BCNF. Every database used 3nf. It is the best normal form. Because provides best decomposed relation having fully lossless join & dependency preservation.
Different normal forms are 1nf, 2nf, 3nf & BCNF. Every database used 3nf. It is the best normal form. Because provides best decomposed relation having fully lossless join & dependency preservation.
Neha said:
1 decade ago
Please make me understand these forms of normalization.
Rizni zuha said:
10 years ago
Can you some one explain for me?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers