Question

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

The question was asked by my school teacher while I was bunking the class.

This interesting question is from Database Design Process in section Normalization of Database Management

Answer 1

The correct answer is (a) Dept name, year->size

To explain: The process of taking a normalized schema and making it nonnormalized is called denormalization.