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.
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.
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.
Elias joseph said:
8 years ago
Normal form is the basic procedure to aquire in order to remove anomalies in the database so as to make the well structure of your data and well difined in norm form there most three basic kind of norm which are 1NF, 2NF and 3NF.
(3)
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.
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.
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.
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.
Manoj Bhardwaj said:
8 years ago
The main motto of Normal form is to free from anomalies So the anomalies can be prevented through Normal form.
Keshav bhardwaj said:
9 years ago
I think referential integrity constraints also can be used to prevent modification anomalies.
Nanda said:
1 decade ago
By normalization the redundancy of the database data is reduced.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers