logo

Entity Relationship Diagram (ERD) for Books, DVD, Patron, Loan, Fine

4 Pages588 Words328 Views
   

Added on  2019-09-26

About This Document

This article explains the Entity Relationship Diagram (ERD) for Books, DVD, Patron, Loan, Fine. It covers the attributes of each entity and foreign keys. Additionally, it discusses the concept of normalization in database design and the first, second, and third normal form rules.

Entity Relationship Diagram (ERD) for Books, DVD, Patron, Loan, Fine

   Added on 2019-09-26

ShareRelated Documents
Assignment ExplanationThe assignment is prepared in word document in APA format by using Microsoft Visio.In this I have develop an Entity Relationship Diagram (ERD) for showing the scenario.For representing the scenario, I have taken five entities i.e. Books, DVD, Patron,Loan, Fine. And the attributes have been developed for each entities.First I have select the entity Books and it contain two primary key and three foreign key :-The two primary key :-1.Books ID2.Books nameI contain three foreign key:-1.Books Patrons ID2.Books Loan ID3.Books Fine IDSo the first foreign key Books Patrons ID has contain seven attributes:-a)Patrons Nameb)Patrons Addressc)Patrons Investmentd)Patrons Typee)Patrons Investment Typef)Patrons Capacity g)Patrons Total InvestmentThe second foreign key Books Loan ID has contain three attributes:-a)Loan type b)Simple interestc)Compound interestThe third foreign key Books DVD ID has contain eight attributes:-a)DVD Priceb)DVD Namec)DVD Types
Entity Relationship Diagram (ERD) for Books, DVD, Patron, Loan, Fine_1
d)DVD Memorye)DVD Capacityf)DVD Data accessg)DVD Cost of Storageh)DVD Types of StorageAfter all these I have create a table Fine. And the entity Fine ID contain three attributes:-a)Loan IDb)Patron IDc)DVD IDAnd it is the foreign key of three table i.e. Patron, Loan, DVD .The screenshot of the diagram prepared in word document in APA format by using Microsoft Visio.
Entity Relationship Diagram (ERD) for Books, DVD, Patron, Loan, Fine_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
The MyLibrary website
|25
|2842
|492

ITECH 1006 - Assignment On Database Management Systems
|12
|1416
|588

Normalization of Charity and Customer Supply Databases
|6
|818
|226

A Study on Functional Dependency and Relational Schema
|7
|557
|237

Database Design in MS Access and MYSQL - Assignment
|22
|711
|222

Entity Relationship Diagram (ERD) represents the real-world objects as Entities and relationship between them.
|15
|1780
|11