The process of analyzing relation schemas to achieve minimal redundanc – McqOptions

MCQOPTIONS

1.	The process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as
A.	Normalization of data
B.	Denomination of data
C.	Isolation of data
D.	De-normalization of data
Answer» B. Denomination of data

Discussion

No Comment Found

Related MCQs

A function that has no partial functional dependencies is in _______ form :
4NF is designed to cope with :
5NF is designed to cope with :
A BCNF is :
Every Boyee-Codd normal form is in
Designers use which of the following to tune performance of systems to support time-critical operations?
In the schema (dept name, size) we have relations total inst 2007, total inst 2008 . Which dependency have lead to this relation ?
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009) .Here the only functional dependencies are from dept name to the other attributes .This relation is in
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies:F1->F3F2->F4(F1,F2)->F5in terms of normalization, this table is in
Consider the following functional dependencies in a database. Date_of_Birth->Age Age->Eligibility Name->Roll_number Roll_number->Name Course_number->Course_name Course_number->Instructor (Roll_number, Course_number)->GradeThe relation (Roll_number, Name, Date_of_birth, Age) is