The library handles books. Books have a title, author, ISBN, and additional relevant data you think are needed. Books are identificed by a barcode. There can be many copies of the same ISBN but only one copy of an actual book per barcode. These books reside in the library on shelf locations. A shelf location is made up of the aisle, row, cabinct, and shelf numbers A book can have only one location, but shelves are wide and can contain many books. Some shelves may be left empty on purpose. The library lends books to patrons. A patron is identified by an ID Additional information about each patron, mcluding namc, address, telephone numbers, and email addresses must also be kept. A patron can have many telephone numbers and emails. The library keeps track of which books have been lent to each patron, when the books were lend out, when they were returned. Also keep track of the categornes of each book. A book can have many categories, such as MIS, Biology, Literature, etc., but must have at least one.

The library handles books. Books have a title, author, ISBN, and additional relevant data you think are needed. Books are identificed by a barcode. There can be many copies of the same ISBN but only one copy of an actual book per barcode. These books reside in the library on shelf locations. A shelf location is made up of the aisle, row, cabinct, and shelf numbers A book can have only one location, but shelves are wide and can contain many books. Some shelves may be left empty on purpose. The library lends books to patrons. A patron is identified by an ID Additional information about each patron, mcluding namc, address, telephone numbers, and email addresses must also be kept. A patron can have many telephone numbers and emails. The library keeps track of which books have been lent to each patron, when the books were lend out, when they were returned. Also keep track of the categornes of each book. A book can have many categories, such as MIS, Biology, Literature, etc., but must have at least one.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Course : Compilation Techniques 1. Relationship of RE, NFA and DFA
Explain collaborating on To-Do List?
What are ABAP objects?
hello I was wondering if I could get some help creating a UML class diagram from a ERD
Explain MIME header ?
Itil implementation conclusion
When should you use generalising, overfitting, and underfitting?
Specification of validator tools is necessary.
Define race condition.
Explain universal design principle.
In your own words describe what are some advantages to using modular code?
Define the term structured design.