Database Management System
Normalization
Q. The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
A.   BCNF algorithm B.   2NF algorithm C.   3NF synthesis algorithm D.   1NF algorithm
Similar Questions
1. A domain is ______ if elements of the domain are considered to be indivisible units.
A.   Atomic B.   Subatomic C.   Substructure D.   Subset
2. Identify the composite attributes
A.   Salary B.   Credits C.   Section_id D.   None of the mentioned
3. a)
A.   First B.   Second C.   Third D.   Fourth
4. If a relation is in BCNF, then it is also in
A.   1 NF B.   2 NF C.   3 NF D.   All of the mentioned
5. key attribute is functionally dependent primary key, then the relation will be in
A.   First normal form B.   Second normal form C.   Third form D.   Fourth normal form
6. If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.
A.   DKNF B.   BCNF C.   Fourth D.   Third
7. a)
A.   Data dictionary B.   data repository C.   Index data D.   Metadata
8. a)
A.   Autonumber B.   Boolean C.   Sequential key D.   Sequential number
9. A dependency exist between two columns when
A.   Together they constitute a composite key for the table B.   Knowing the value in one column determines the value stored in another column C.   The table is in 3NF D.   Together they constitute a foreign key
10. In the __________ normal form, a composite attribute is converted to individual attributes.
A.   First B.   Second C.   Third D.   Fourth
DATABASE MANAGEMENT SYSTEM TOPICS