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
Explanation:The process of taking a normalized schema and making it nonnormalized is called denormalization. 8. 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