We need to create a database for the Circulation Department of a public library. The database will store information about the patrons, books, and circulation. It contains the following:4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows: PATRON table records a patron’s ID, name, address, phone number, and email address.BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book.BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table.CHECKOUT table records the date of check-out, patron’s ID, the identifier of the book copy from the BOOK_COPY table, and the due date. question:-Write a list of business rules for the Circulation Department of a public library database.

Database schema: The database schema would have the following structure (primary keys are italicised…

Answered: We need to create a database for the…

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

Related questions

Concept explainers

Question

We need to create a database for the Circulation Department of a public library. The database will store information about the patrons, books, and circulation. It contains the following:

4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows:

PATRON table records a patron’s ID, name, address, phone number, and email address.
BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book.
BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table.
CHECKOUT table records the date of check-out, patron’s ID, the identifier of the book copy from the BOOK_COPY table, and the due date.

question:-Write a list of business rules for the Circulation Department of a public library database.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions