Download Aptitude Crack
img not found img not found

The Relational Model and Normalization

Q1: A relation in this form is free of all modification anomalies.

A First normal form

B Second normal form

C Third normal form

D Domain/key normal form

ANS:D - Domain/key normal form

After a SQL database is in third normal form, you've eliminated most, but not all, chances of modification anomalies. Normal forms beyond the third are defined to squash those few remaining bugs.

Domain-key normal form (DK/NF):

Boyce-Codd normal form (BCNF), fourth normal form (4NF), and fifth normal form (5NF) are examples of such forms. Each form eliminates a possible modification anomaly but does not guarantee prevention of all possible modification anomalies. Domain-key normal form, however, provides such a guarantee.



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.