Home Library Relation Assignment

 

Sample Assignment

Table 1 : Home Library

Below is the Home Library table

















































































ISBNTitleAuthor_LastNameAuthor_FirstNamePublisherDateEditionMedia
369852CosmosSaganCarlRandom House19801Book
741258No ScretsSimonCarlyElektra19721CD
654789Symphony No 3 Dur Eroica Op 55BeethovenLudwig 18051CD
789654On the Decay of the Art of LyingTwainMarkProject Gutenberg18801eBook
258963The Adventures of Sherlock HolmesConan DoyleArthurProject Gutenberg 1eBook
125896The Divine ComedyAlighieriDanteProject Gutenberg 1eBook
357951The Hitchhickers Guide to the GalaxyAdamsDouglasPan books19791Book
852369The Return of the King, SoundtrackShoreHowardReprise20031CD
831975Unseen AcademicalsPratchettTerryDobleday20091Book
 

Dependency diagram

The dependency diagram for the Home Library table is as shown below.

 

 

 

 

 

 

 

 

1NF Relations

The 1NF relation involves removing repeating groups in individual tables, creating separate tables for every set of related data, and identifying the primary key in the related data. The Home Library relation to 1NF is as shown below.








ISBNTitleAuthor_LastNameAuthor_FirstNamePublisherDateEditionMedia

 

2NF Relations

In 2NF all non-key attributes should be fully functional and dependent on the primary key. The Home Library 2NF relation is as shown below.



ISBNAuthorIDPublisherID

 


ISBNTitle

 



AuthorIDAuthor_LastNameAuthor_FirstName

 





PublisherIDPublisherDateEditionMedia

 

3NF Relations

In the 3NF relation there should not be any transitive functional dependancies.

The 3NF relations for the Home Library table are as shown below




ISBNAuthorIDPublisherIDTitle

 



AuthorIDAuthor_LastNameAuthor_FirstName

 





PublisherIDPublisherDateEditionMedia

 

 

 

 

 

 

 

Relational Schema

The relational schema for the 3NF relations is as shown below.

BOOK(ISBN[PRIMARY KEY], Publisher, Date, Edition, Media)

When creating the table BOOK, below are the constraints used.

CREATE TABLE BOOK(

ISBN INT NOT NULL,

Publisher VARCHAR (100) NOT NULL,

Date DATE,

Edition VARCHAR (100),

PRIMARY KEY (ISBN)

);

 

 

AUTHOR(ISBN[FOREIGN KEY], Author_LastName, Author_FirstName)

The unique field in the Home Library is the ISBN which becomes the primary key in the BOOK relation and the foreign key in the AUTHOR relation.

When creating the table AUTHOR, below are the constraints used.

CREATE TABLE(ISBN INT NOT NULL,Author_LastName VARCHAR (100) NOT NULL,Author_FirstName VARCHAR (100),PRIMARY KEY (ISBN));

For this assignment contact www.punjabassignmenthelp.com

 

 

Comments

Post a Comment

Popular posts from this blog

ACC030243 Corporate Governance SCU Assignment 2

ACC03043 Corporate Governance Assessment Task 2 Due Date:                          Sunday 5 August 2018 Length:                                2,000 words total (+/- 10%). Reference list and cover sheet details are not included in this word-limit total. Weighting:                        25% of total unit marks Assessment Criteria: Demonstration of knowledge of the issues and evidence of wide reading to support your analysis Demonstration of your ability to apply the knowledge to identify keys issues leading to your recommendations Evidence of sound reasoning and the exercise of professional judgement to support your recommendations Development and statement of concise recommendations for presentation to the AICD Overall structure and professional presentation of the report to the AICD High quality written communication of concepts and terms in ordinary English as not all readers of the report can be assumed to be specialists competent in corporate governance Case Study ‘
Read more

Accounting Assignment Solution

Image
Accounting Assignment Solution Are you an accounting student? Are you laden with tons with assignments, homework that is making your life immensely hectic? So, we Punjab assignment help are here to provide you the benefit of our accounting assignment Solution services, in order to get the services contact us at www.punjbassignmenthelp.com Well, you should know that you are just not the only one. Being an accountancy student is just not easy. It involves the business language of the society. Accounting involves maintenance of finances, investments and laying down all calculations for accounting assignments. A general guideline on Financial Accounting assignment solutions: Try to understand and learn the concepts well from the basic since the beginning. Just as soon as the matter starts in class, give full concentration as to what is being taught in classroom. This not only saves time but also gives you enough time to prepare. Always try to grab the concepts well. In case you are hav
Read more

CSG1207 | DATABASE DESIGN AND IMPLEMENTATION ONLINE STORE

Image
CSG1207 | DATABASE DESIGN AND IMPLEMENTATION ONLINE STORE | DATABASE COMPUTER ASSIGNMENT HELP Task 1 (Database Design) This task is to design a database for the given scenario on the following page. Your final database design should include approximately eight entities. Note: The scenario for this assignment is the same as the one from Task ¾ of Assignment 1. State any assumptions you have made regarding your database design at the starting of the database design document. Do not make any assumptions that significantly change the structure of the scenario, as this may make Task 2 of the assignment more inappropriate. You need to make assumptions that affect your database design. Finally, create a data dictionary with an entry for each entity in your database. The entries should list the entity name, a description of its purpose, a list of attributes, and details of any constraints applied to attributes. List the entries in your data dictionary in an applicable table creation order that
Read more