Assignmenttasktable 1 home library, Ask an Expert

Programming

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.

View complete question

DBMS, Programming

Category:- DBMS
Reference No.:- M92790031

Have any Question?Write your Review or question?

Related Questions in DBMS

Question 1 what isdata-manipulation language dml there are

Question: 1. What isData-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last_ ...

Sqlwrite a select statement that returns three columns from

SQL Write a SELECT statement that returns three columns from the Vendors table: VendorContactFName, VendorContactLName, and VendorName. Sort the result set by last name, then by first name.

Query 1 the bookstore has decided to keep track of the

Query 1: The bookstore has decided to keep track of the vendors' information. In order to do this, one new table will be added to the database. The schema for this table, as related to the existing tables, is the followi ...

Sql assignmentin these exercises youll enter and run your

SQL Assignment In these exercises, you'll enter and run your own SELECT statements. You will use the MyGuitarShop database for these queries. If you do not already have the MyGuitarShop database, the SQL script and the i ...

In sql database questions phase-1 in 100 words what steps

In SQL Database Questions: Phase-1 In 100 words, what steps can one take to avoid losing work? Which command is used to save changes to the database? What is the syntax for this command? Phase-2 In 100 words, explain the ...

Real time analytics - data analytics assignment -this is a

Real Time Analytics - Data Analytics Assignment - This is a business analytics project aimed at generating innovative analytics solutions for a Global Food Consulting firm working in the area of Animal agriculture and fa ...

Football association of zambia faz super leaguethe faz has

Football Association of Zambia (FAZ) Super League The FAZ has recently decided to reorganise their operations to support both existing and possibly expanded league operations in Zambia and part of preparation for the 201 ...

Database design and development assignment -assessment task

Database Design and Development Assignment - Assessment task - 1. Normalization a) Map the ERD, from the sample solution, into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations m ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

Sql transactions exercisesconsider table itemnameprice

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*price Where name = 'pencil'; Insert Into Ite ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask DBMS Expert