Digital Academic Solutions

Trainer Database Modelling and Normalization

SOLUTION AVAILABLE AT: http://libraay.com/downloads/trainer-database-modelling-and-normalization/

Problem:

Using the given table/relation, do the following:

  1. Draw a dependency diagram to show the functional dependencies in the relation
  2. Decompose the following table into a set of 3NF relations
  3. Draw a relational schema for your 3NF relations and show the referential integrity constraints
  4. Manually drawing the dependency diagrams is not acceptable.
Trainer_ID Trainer_Name Room_No Room_Seats Class_Session Class_Name Class_Day School
101 Alana Fredrick 54A 36 9:00 ITC114 Mon Computing
102 George Edwards 22 28 9:00 ITC333 Mon Computing
103 Lilly Nelly 59 38 12:30 BUS350 Tues Business
104 Eddy Brown 53 30 12:30 ITC114 Thurs Computing
102 George Edwards 59 38 4:00 ITC504 Fri Computing
103 Lilly Nelly 18 24 12:30 BUS360 Wedn Business
102 George Edwards 53 30 9:00 ITC201 Wedn Computing
105 Sam Wang 22 28 4:00 ITC556 Tues Computing
106 Yifeng Chong 58 38 9:00 ITC556 Thurs Computing

SOLUTION AVAILABLE AT: http://libraay.com/downloads/trainer-database-modelling-and-normalization/

Leave a Reply

Your email address will not be published. Required fields are marked *



Solutions Authored by 15+ Years Experienced Industry Experts