Database Management System
Normalization
Q. 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.   Fourth NF B.   BCNF C.   Third NF D.   Second NF
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