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