Saturday, 27 April 2013
Objective:
The objective of the assignment is to revise
the old concepts as well as setting focus on the new ones. Self practice will
not only clear your concepts further but will also provide a strong base in
future.
Reference:
Please
refer to the case study given at the end and complete the following tasks:
Task#1 [Marks: 5]:
Draw an Entity Relationship Diagram (ER Model)
for the given case study along with proper associations and cardinalities.
Task#2 [Marks 5]:
Derive the tables from the ER model and
normalize up to third normal form (3rd NF)
Task#3 [Marks 10]:
De-normalize the database (obtained after
completing task#2) by using the “collapsing tables” technique.
