DRAW A DEPENDENCY DIAGRAM TO SHOW THE FUNCTIONAL FEPENDENCIES IN THE RELATION

Qualified Writers
Rated 4.9/5 based on 2480 reviews

100% Plagiarism Free & Custom Written - Tailored to Your Instructions

Normalisation

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. 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

 

Rationale

This assessment item is designed to test your understanding of the normalisation process based on existing data in order to minimise redundancies and data anomalies.

Marking criteria

The marking criteria for this assignment are:

Task

HD

DI

CR

PS

FL

Decompose relation into 3NF and show relational schema for each relation and referential integrity constraints

All relations in 3NF and all partial and transitive dependencies removed, each relation shows correct referential integrity constraints

All relations in 3NF and all partial and transitive dependencies removed, each relation shows referential integrity constraints

All relations in 3NF and all partial and transitive dependencies removed, most relations show referential integrity constraints

All relations in 3NF and all partial and transitive dependencies removed, some relations show referential integrity constraints

Incomplete decomposition or relations not in 3NF, no relations show integrity constraints

Create an ERD & show all entities, PK & KF attributes,
relationships, cardinality & optionality

Comprehensive and accurate ERD that contains all entities, PK and FK attributes, associative entities included if required, all relationships shown and identified with correct cardinality and optionality

Detailed and accurate ERD that contains all entities, PK and FK attributes, associative entities included if required, all relationships shown and identified with correct cardinality

Thorough & reasonably accurate ERD that contains all entities, PK and FK attributes, associative entities included if required, all relationships shown with correct cardinality

Adequate ERD that contains most entities, PK and FK attributes, associative entities included if required, all relationships shown with cardinality

Incomplete or irrelevant ERD that contains some entities, relationships, and cardinality

 

Price: £109

100% Plagiarism Free & Custom Written - Tailored to Your Instructions