The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID. This table is in which normal form?
A) 1NF
B) 1NF and 2NF
C) 1NF, 2NF and 3NF
D) 1NF, 2NF, 3NF and BCNF

Question

The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID. This table is in which normal form? 
A) 1NF 
B) 1NF and 2NF 
C) 1NF, 2NF and 3NF 
D) 1NF, 2NF, 3NF and BCNF

Quizplus · Accepted Answer

The Answer of The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID. This table is in which normal form? 
A) 1NF 
B) 1NF and 2NF 
C) 1NF, 2NF and 3NF 
D) 1NF, 2NF, 3NF and BCNF

The Exhibit Shows a Table Called Housing Relation That Relates