Using the Home library relation above:
|
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
|
°Book
|
|
258963
|
The Adventures of Sherlock Holmes
|
Conan Doyle
|
Arthur
|
Project Gutenberg
|
I
|
1
|
°Book
|
|
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
|
1. Draw a deperldency diagram to show the functional dependencies that exist in this relation.
2. Decompose the Home Library relation into a set IMF relations and draw a dependency diagram for ea. of the 3NP relations. Develop the Relational Schema for each of these SNP relations and show the referential integrity constraints that apply.
Rationale
This assessment item is designed to test your ability.
- Gther, analyse and model business requirements using Enhanced Entity Relationship Diagrams (EERD),
- Critically analyse a database design and apply Normalisation Theory and techniques.