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

Unit 17 Understanding and leading change

Image
ICON COLLEGE OF TECHNOLOGY AND MANAGEMENT Pearson BTEC HND in Business Unit 17 Understanding and Leading Change (RQF) Assignment Brief Session: September 2018 Unit 17 Understanding and Leading Change ICON College of Technology and Management  Pearson BTEC HND in Business (RQF) Unit 17: Understanding and Leading Change Session: September 2018 Coursework Recommended Word limit: 3,500–4,500 This Unit will be assessed by assignment, power point presentation and question and answers on the presentation. You are strongly advised to read “Preparation guidelines of the Coursework  Document” before answering your assignment. Assignment Context and Scenario: In the current competitive environment, orgnisations need to change in order to survive. This change could be based on changes in organizational structure based on changed models, changes in products, etc.  You have been hired by a UK-based organisation of your choice to recommend how the large scale changes w...
Read more

The Disguised . Jewel of Method Area

History of Method Page Refuted Formulating an essay, or some other old fashioned paper to do this question, isn"t just generating. One of the many definite most confusing servings of your document is known as a literature evaluation. Just simply communicating, you cannot reduce and mixture from an previously cardstock. Let you know that you intend to analyze your good results. The do my paper third area of the section will investigate the exact career-ways that Becky adhered to to ready the fabric for investigation and translate her statistics. The amount of researching way that you undertake is determined by the shape of examine. Being a researcher, you"re frequently forecasted to bring about certain your research and ideas tend not to injury most people in the first place. A dissertation modifying support is intended to match the specifications of Ph.D. learners who want to complete their dissertation. You may want to prepare an analysis paper for a percentage of your caps...
Read more

Information Technology Assignment Help

Image
Information Technology Assignment Help | IT Assignment Samples IT or Information Technology refers to that engineering discipline where students are taught the application of telecommunications devices, especially computers. The primary focus in the subject is on the operations related to computer science like storage, transmission, retrieval, and manipulation of data. Since the nature of subject is quite dynamic, university and college faculty prefer demonstrative and interactive teaching methods, where students are supposed to submit high quality and original Information Technology assignment .   IT assignment  could be based on any topic depending on the core subject it is about. But whatever may the topic be, Punjab assignment Help experts are fully equipped and capable to offer you splendid assignment help. So whether you need help with your IT assignment or with the communication medium paper, our professional writers and subject specialists can solve all your acad...
Read more