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
A. Fourth NF
B. BCNF
C. Third NF
D. Second NF
Answer:A
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
A. Fourth NF B. BCNF C. Third NF D. Second NF
Explanation:BCNF has only one normal form. 9. Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.