CSC 4480: Principles of Database Systems

Phase 3: Relational Model

Turcotte Hockey School

 

Click for Relational Model

 

 

2. Functional Dependencies

 

         Person Table

 

UID (Name, DOB)

 

         Work Eligibility Table

 

WorkID Country

 

 

         Instructor Table

 

ID (Address, Emergency Contact, Status, Phone)

 

 

         Student Table

 

No column is dependent on anything other than the full primary key

 

 

         Guardian Table

 

ID (Address, Emergency Contact, Phone)

 

         Group Table

 

GroupID (Group Name, Skill Level)

 

 

         Level Table

 

LevelID (Name, Age Group)

 

         Order Table

 

No column is dependent on anything other than the full primary key

 

         Order Line Table

 

No column is dependent on anything other than the full primary key

 

         Merchandise Table

 

ItemID (Name, Price)

 

         Session Table

 

No column is dependent on anything other than the full primary key

 

         Rink Table

 

RinkID (Name, Address, Phone, E-Mail, Hockey Enrollment, Ice Sheets)

 

 

3. Changes From Previous Table

 

I added an Order Line table.