Database - The Relational Model and Normalization - Discussion

Discussion :: The Relational Model and Normalization - General Questions (Q.No.2)


The different classes of relations created by the technique for preventing modification anomalies are called:

[A]. normal forms.
[B]. referential integrity constraints.
[C]. functional dependencies.
[D]. None of the above is correct.

Answer: Option A


No answer description available for this question.

Loga Priya said: (Mar 6, 2011)  
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: (Jun 27, 2011)  
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: (Aug 28, 2011)  
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: (Dec 30, 2011)  
BY using narmal form we remove duplication attributes of table.

Nanda said: (Jun 22, 2012)  
By normalization the redundancy of the database data is reduced.

Manish Choudhary said: (Nov 1, 2012)  
Normal form used for remove the independence for data in the relation and normal form remove the duplication attribute from table.

Ansar said: (Dec 10, 2013)  
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: (Jun 4, 2014)  
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.

Neha said: (Aug 31, 2014)  
Please make me understand these forms of normalization.

Rizni Zuha said: (Sep 5, 2015)  
Can you some one explain for me?

Kirti Karadge said: (Oct 14, 2015)  
Please tell me the forms of normalization.

Alok said: (Nov 24, 2015)  
Explain this answer please?

Keshav Bhardwaj said: (Dec 25, 2016)  
I think referential integrity constraints also can be used to prevent modification anomalies.

Manoj Bhardwaj said: (Mar 24, 2017)  
The main motto of Normal form is to free from anomalies So the anomalies can be prevented through Normal form.

Elias Joseph said: (Jul 3, 2017)  
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.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.