Designing a simple database for a local neighborhood library

Assignment Help Marketing Research

Reference no: EM131666487

Imagine you are designing a simple database for a local neighborhood library. The following business rules apply for checking out a book.

a. Each check out transaction should be attributed to a customer, who is a registered member of the library. Any new customer must be registered first.

b. A customer can check out multiple books in a single transaction

c. A library employee must check out each book

d. The due dates vary by book and transaction

e. The title and author of each borrowed book should be recorded

f. There are multiple copies of certain books, but customer can only borrow one copy of the book

g. Any other assumptions that seem appropriate

Based on these business rules, showing all resulting tables with their attributes and the relationships between these tables. Make sure your output is in a normalized form .

Reference no: EM131666487

Questions Cloud

How the chosen platform will help achieve the business goals : Briefly describe how the chosen platforms will help achieve the business goals you discussed in Milestone One.

Powerpoint lecture in unit : Based on what you have read in the Christopherson text and what you've seen in the powerpoint lecture in this unit, please do the following:

Identify the successful practices : Evaluate your organization or another selected organization, and discuss how the leaders influence subordinates' performance.

Location on earth where ice mass is growing : What is the only notable location on earth where ice mass is growing? What is causing it to grow?

Designing a simple database for a local neighborhood library : Each check out transaction should be attributed to a customer, who is a registered member of the library. Any new customer must be registered first.

Explain the different organizational culture aspects : Discuss what you believe would be the different organizational culture and local culture aspects that you would have to take into consideration if your company

Humans are extremely good at recognizing familiar faces : Considerable disagreement exists about the extent to which our brains are composed of well-defined modules, each shaped by selection to carry out specialized

Why the earth undergoes seasons : What causes it to be hotter in the summer and cooler in the winter? How can it be winter on half of the planet while it is summer on the other half?

Write an e-mail message to the owners of the clinic : Write an e-mail message to the owners of the clinic on how the organization could answer these three questions.

User Account

All Pages