Draw dependency diagram to show the functional dependencies

Assignment Help Database Management System

Reference no: EM131952373

Assignment

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 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	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.

NOTE

For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: "How to normalise database relations in 3 quick steps?"

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

Reference no: EM131952373

Questions Cloud

What are some of the legal issues an organization : Electronic signatures are often used now. What are some of the legal issues an organization and HR should be concerned with?

Describe difference between hard data and soft data : Describe the difference between hard data and soft data. What are the unique advantages of each type of data in terms of obtaining information.

Develop five valid survey items for each of your dimensions : One of the problems encountered by universities is developing reliable and valid course evaluation survey instruments. Choose a class you took last semester.

Discuss the influence the decision-making process : Examine their own decision-making process as well as use a creative method to illustrate the stages of the process.

Draw dependency diagram to show the functional dependencies : Draw a dependency diagram to show the functional dependencies that exist in this relation. Decompose the Home Library relation into a set of 3NF relations.

How could police and the media partners help : What strategies could police employ to ensure an accurate picture of the citizens, crime problem, and solutions for addressing the crime problem

Defend why you feel your survey items are valid : A manager for the Golden Bear publishing company found out that you are taking quality management. The manager desires to improve her supply chain performance.

Develop five critical-incident survey items : For your performance dimensions in Problem, develop five critical-incident survey items for each dimension. Explain how you would demonstrate that these items.

What are some examples of statistical thinking : The concept of statistical thinking is an important theme in this chapter. What are some examples of statistical thinking?

User Account

All Pages