We're Open
+44 7340 9595 39
+44 20 3239 6980

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

  100% Pass and No Plagiarism Guaranteed

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

Task

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

 


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: DRAW A DEPENDENCY DIAGRAM TO SHOW THE FUNCTIONAL DEPENDENCIES IN THE RELATION
  • Price: £ 109
  • Post Date: 2018-11-09T12:37:42+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

DRAW A DEPENDENCY DIAGRAM TO SHOW THE FUNCTIONAL DEPENDENCIES IN THE RELATION DRAW A DEPENDENCY DIAGRAM TO SHOW THE FUNCTIONAL DEPENDENCIES IN THE RELATION
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

My order went 3 hours late and I also went mad. Then the customer support team calmed me down and offered me a flat discount of 50%. However, I did get my order and chilled out as the work was exactly what I requested. Next time I would place my order a bit sooner to save any trouble.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

My writer did a small error in my work but it was fixed by him shortly. The work is admirable and I have submitted it. Now hoping for the best results. I would inform you soon.