Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

NormalisationValue:13%Due date:23-Apr-2018Return date:15-May-2018Submission method optionsAlternative submission method Task Table 1: Home Library ISBN Title Author_LastName Author_FirstName Publisher...

1 answer below »
NormalisationValue:13%Due date:23-Apr-2018Return date:15-May-2018Submission method optionsAlternative submission method
Task

Table 1: Home Library

ISBNTitleAuthor_LastNameAuthor_FirstNamePublisherDateEditionMedia
369852CosmosSaganCarlRandom House19801Book
741258No SecretsSimonCarlyElektra19721CD
654789Symphony No 3 Dur Eroica Op 55BeethovenLudwig18051CD
789654On the Decay of the Art of LyingTwainMarkProject Gutenberg18801eBook
258963The Adventures of Sherlock HolmesConan DoyleArthurProject Gutenberg1eBook
125896The Divine ComedyAlighieriDanteProject Gutenberg1eBook
357951The Hitchhikers Guide to the GalaxyAdamsDouglasPan books19791Book
852369The Return of the King, SoundtrackShoreHowardReprise20031CD
831975Unseen AcademicalsPratchettTerryDoubleday20091Book

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.
3. Draw the Relational Schema for each of these 3NF relations and show the referential integrity constraints that apply.

NOTE

For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.youtube.com/watch?v=vkUyuLLgmwQ

Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

Rationale

This assessment aligns with the following subject outcomes:

  • be able to critically analyse a database design and apply normalisation theory and techniques;
Marking criteria

Each task is worth5 marks. The marking criteria for this assignment is:

TASKSHDDI

CR
PASS
FAIL
TASKS 1The dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependenciesThe dependency diagram accurately identifies and correctly shows all PKs and most functional, partial, and transitive dependenciesThe dependency diagram identifies and shows most PKs and some functional, partial, and transitive dependenciesThe dependency diagram identifies and shows few PKs and few functional, partial, and transitive dependenciesrelations and includes the related entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities.The dependency diagram identifies and shows few or no PKs and few or no functional, partial, and transitive dependencies and optionalities.
TASK 2The set of relations is in 3NF and accurately identifies all PKs and all the relevant attributesThe set of relations is in 3NF and accurately identifies all PKs and most of the relevant attributesThe set of relations is in 3NF identifies most PKs and some of the relevant attributesThe set of relations is mainly in 3NF and identifies some PKs and some of the relevant attributesThe set of relations is not in 3NF and identifies few or no PKs and few or none of the relevant attributes
TASK 3The relational schema accurately describes each entity and correctly shows all of the referential integrity constraintsThe relational schema accurately describes each entity and correctly shows most of the referential integrity constraintsThe relational schema describes each entity and shows some of the referential integrity constraintsThe relational schema describes most entities and shows some of the referential integrity constraintsThe relational schema describes few entities and shows few or none of the referential integrity constraints

Requirements

Either save yourdiagrams in aPDF file or embedthem in a Word document.

Don't use any other file formats

Please include your student ID, name and subject code inyour submission.

Answered Same Day Apr 15, 2020 ITC556 Charles Sturt University

Solution

Shikha answered on Apr 20 2020
143 Votes
Student Name
Student ID        2
ITC556 – Database Systems
Submitted By
Course
Professo
Date
Assessment 3
Normalization – Home Li
ary
    ISBN
    Title
    Author_LastName
    Author_FirstName
    Publishe
    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
    Ludwing
    
    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
    Arthu
    Project Gutenberg
    
    1
    eBook
    125896
    The Divine Comedy
    Alighieri
    Dante
    Project Gutenberg
    
    1
    eBook
    357951
    The Hitchhikers Guide to the Galaxy
    Adams
    Douglas
    Pan...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here