ProductsLogo
LogoStudy Documents
LogoAI Grader
LogoAI Answer
LogoAI Code Checker
LogoPlagiarism Checker
LogoAI Paraphraser
LogoAI Quiz
LogoAI Detector
PricingBlogAbout Us
logo

Database Design for Public Library

Verified

Added on  2019/09/19

|5
|353
|173
Project
AI Summary
The assignment content describes a case study on designing a database for a public library to manage information about the library, its books, and rent records. The database design involves multiple tables, including Patron, Book, Author, Book_author, and Rent, with primary and foreign keys. An ER-diagram and data structure diagram are also provided, along with links to YouTube videos that demonstrate normalization, relations, ER-diagrams, Visio, and keys.

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.
Document Page
A Library Data Case Study
STUDENT NAME:
2 November, 2016

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Contents
DATABASE STORY..............................................................................................................................................2
RELATIONS............................................................................................................................................................2
ER DIAGRAM.........................................................................................................................................................3
DATA STRUCTURE DIAGRAM..........................................................................................................................4
YOUTUBE VIDEO LIST........................................................................................................................................4
1 | P a g e
Document Page
DATABASE STORY
The database design is about a public library. It has been designed to manage the information
about the library, its books and the rent information in the library. Earlier they has the book
keeping system in which the data was on paper and it was difficult to manage the records
manually. Hence, the library decided to have its own DBMS. The database will have multiple
tables which will hold the information about the people who rent the books, the books present
in the library and their authors etc. This will make the entire management easier to implement
and handle. This will avoid errors of book keeping, redundancy in the data and theft of the
books. Moreover there will be database files for the records to all the past information and
add up the growing rent records.
RELATIONS
Relation as per the original data in the assignment:
Library (PatronName , HomePhone#, LibraryCard #, Call#, DueDate, BookName,
AuthorName)
Relations after breakdown of the original relation and addition of primary and foreign keys
are:
1. Patron(LibraryCard #, PatronName, HomePhone#)
2. Book (book_id, bookname)
3. Author (author_id, authorname)
4. Book_author(book_id, author_id)
5. Rent(LibraryCard #, Call#, DueDate, book_id)
Note: italics – foreign key and underline – primary key.
2 | P a g e
Document Page
ER DIAGRAM
The ER-diagram for the above relations is as follows:
3 | P a g e

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
DATA STRUCTURE DIAGRAM
The data structure diagram is as follows:
YOUTUBE VIDEO LIST
1. Normalization: https://www.youtube.com/watch?v=UrYLYV7WSHM
2. Relations: https://www.youtube.com/watch?v=NvrpuBAMddw
3. ER-diagram: https://www.youtube.com/watch?v=mQ4D0drMrYI
4. Visio: https://www.youtube.com/watch?v=sIX80pvJnMY
5. Keys: https://www.youtube.com/watch?v=FCtGbrou5DM
4 | P a g e
1 out of 5
[object Object]

Your All-in-One AI-Powered Toolkit for Academic Success.

Available 24*7 on WhatsApp / Email

[object Object]