Explanation:The process of taking a normalized schema and making it nonnormalized is called denormalization. 7. In the schema (dept name, size) we have relations total inst 2007, total inst 2008 . Which dependency have lead to this relation ?
A. Dept name, year->size
B. Year->size
C. Dept name->size
D. Size->year
Answer:A
Explanation:The process of taking a normalized schema and making it nonnormalized is called denormalization. 7. In the schema (dept name, size) we have relations total inst 2007, total inst 2008 . Which dependency have lead to this relation ?
A. Dept name, year->size B. Year->size C. Dept name->size D. Size->year