Create centralized relational database using bottom up method.
(a) Recognize a single un-normalized relation for the above scenario.
(b) Recognize the primary key for the un-normalized relation.
(c) Recognize all functional dependencies available in the above scenario.
(d) From identified functional dependencies, produce a set of Boyce Codd Normal form relations. BCNF. (No need to do 1NF, 2NF and 3NF).