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

DRAW A DEPENDENCY DIAGRAM TO SHOW THE FUNCTIONAL DEPENDENCIES

  100% Pass and No Plagiarism Guaranteed

DRAW A DEPENDENCY DIAGRAM TO SHOW THE FUNCTIONAL DEPENDENCIES

Task

 

Home Library

 

ISBN

Title

Author_LastName

Author_FirstName

Publisher

Date

Edition

Media

369852

Cosmos

Sagan

Carl

Random House

1980

1

Book

741258

No Secrets

Simon

Carly

Elektra

1972

1

CD

654789

Symphony No 3 Dur Eroica Op 55

Beethoven

Ludwig

 

1805

1

CD

789654

On the Decay of the Art of Lying

Twain

Mark

Project Gutenberg

1880

1

eBook

258963

The Adventures of Sherlock Holmes

Conan Doyle

Arthur

Project Gutenberg

 

1

eBook

125896

The Divine Comedy

Alighieri

Dante

Project Gutenberg

 

1

ebbok

357951

The Hitchhikers Guide to the Galaxy

Adams

Douglas

Pan books

1979

1

Book

852369

The Return of the King, Soundtrack

Shore

Howard

Reprise

2003

1

CD

831975

Unseen Academicals

Pratchett

Terry

Doubleday

2009

1

Book

 

Tasks:

 

Using the Home library relation above:

 

  1. Draw a dependency diagram to show the functional dependencies that exist in this relation.
  2. Decompose the Home Library relation into a set of 3NF relations and draw a dependency diagram for each of the 3NF relations.
  3. Develop the Relational Schema for each of these 3NF relations and show the referential integrity constraints that apply.
     

Rationale

 

This assessment item is designed to test your ability to

 

  • Gather, analyse and model business requirements using Enhanced Entity Relationship Diagrams (EERD),
  • Critically analyse a database design and apply Normalisation Theory and techniques.
     

Marking Criteria

 

Marking Rubric

Task

HD

DI

CR

PS

FL

Draw a dependency diagram to show the functional dependencies in the Home Library relation

The dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependencies

The dependency diagram accurately identifies and correctly shows all PKs and most functional, partial, and transitive dependencies

The dependency diagram identifies and shows most PKs and some functional, partial, and transitive dependencies

The dependency diagram identifies and shows few PKs and few functional, partial, and transitive dependencies

The dependency diagram identifies and shows few or no PKs and few or no functional, partial, and transitive dependencies

Decompose the Home Library relation into a set of 3NF relations

The set of relations is in 3NF and accurately identifies all PKs and all the relevant attributes

The set of relations is in 3NF and accurately identifies all PKs and most of the relevant attributes

The set of relations is in 3NF identifies most PKs and some of the relevant attributes

The set of relations is mainly in 3NF and identifies some PKs and some of the relevant attributes

The set of relations is not in 3NF and identifies few or no PKs and few or none of the relevant attributes

Draw a relational schema for each of the 3NF relations and show the referential integrity constraints

The relational schema accurately describes each entity and correctly shows all of the referential integrity constraints

The relational schema accurately describes each entity and correctly shows most of the referential integrity constraints

The relational schema describes each entity and shows some of the referential integrity constraints

The relational schema describes most entities and shows some of the referential integrity constraints

The relational schema describes few entities and shows few or none of the referential integrity constraints

 

Marking Guide

 

Task

Marks

Score

Task 1: Dependency diagram

25

 

Task 2:

   

1. All entities identified

15

 

2. PKs identified

10

 

3. Attributes identified for each entity

10

 

Task 3:

   

1. Relational schema for each entity

10

 

2. Attributes correctly described

10

 

3. PKs correctly described

10

 

4. FKs correctly described

10

 

Total

100

 

Final mark

15

 

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
  • Price: £ 109
  • Post Date: 2018-11-09T08:55:19+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

 DRAW A DEPENDENCY DIAGRAM TO SHOW THE FUNCTIONAL DEPENDENCIES DRAW A DEPENDENCY DIAGRAM TO SHOW THE FUNCTIONAL DEPENDENCIES
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

Oh my god! This writing company has saved me from so many bothering and figured out my problem in the best way possible. I am not fond of reading and when this book review was given to me as part of my coursework, I went into depression. But I must say, my writer came up with an amazing book review covering all the major aspects of the book nicely. I am waiting for other assignments to come so that I would come here again. The place is good and quite reasonable as well which makes it easy for me to manage my budget.