+1-415-670-9189
info@expertsmind.com
Decompose the home library relation
Course:- Database Management System
Reference No.:- EM131944110




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Database Management System

Task

Table 1: 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 DurEroica 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

eBook

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

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.

Answered:-

Verified Expert

The student will understand the concept of functional dependency and the types of full functional dependency, transitive dependency and multi-valued dependency. How to apply the normalization process to recognize the different types of normal forms and how to convert the table into dependency graph and representation of the table.



Put your comment
 
View Conversion
Minimize
  1. user image
    len1944110

    TASK 2 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 TASK 3 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

  2. user image
    len1944110

    Rationale This assessment aligns with the following subject outcomes: • be able to critically analyse a database design and apply normalisation theory and techniques; TASKS HD DI CR PASS FAIL TASKS 1 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 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.



Ask Question & Get Answers from Experts
Browse some more (Database Management System) Materials
A controller action is taking 10 seconds to run. Most of the time is being spent in a view which is a large file.(1000 lines). How will you go about debugging the speed issu
Create one table representing normalized design (3NF) for the important objects and their attributes in a textbook catalogue and accounting office at a university book store
The base application consists of three classes - Doctor, Patient and Hospital. A patient can be a private or public patient and is handled differently in either case. Patien
In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) p
List all salesperson numbers, salesperson names, and their salaries - List the addresses, balances, and invoice numbers of those customers who were sold merchandises in the da
Based on your research and / or common knowledge of a college and the information tracked by a college, describe the entities of the database and the attributes of each entity
Practical experience in using Entity-Relationship and Relational Database modelling techniques - design using an E-R diagram an entity-relationship model of the problem, conv
CSIS 343- Our text discusses SQL injection attacks. Consider a NoSQL database, is it still vulnerable to an SQL injection attack? Why or why not? What are the vulnerabilitie