Develop an e-r diagram for the library database

Assignment Help Database Management System

Reference no: EM13778592

A Database for a Library of a University

Assumptions:

· Each book has different ID (also each book of same name and same author (but number of copies) will have different ID), author name and any additional information you think it is important.

· Students and faculty can borrow books.

· Each student and faculty can borrow books but the book cannot be borrowed by more than one borrower in the same time.

· There is a limited number of books can be borrowed each semester.

· The date of borrowing and return must be registered.

Requirements:

· Develop an E-R diagram for the library database.

· The relation schemas for the library database.

· Normalization of the relations (your relations should be in 4NF)

· SQL statements for creating all tables in your ERD.

· Populate your database with sample data. Each table should have a minimum of five rows.

· SQL queries to test your database:

o Find all students who have borrowed books.

o Find all books name and their authors.

o Any additional query you think it is useful.

Reference no: EM13778592

Questions Cloud

Cultural diversity need issues : What is the definition of this disease/disorder and what are common signs and symptoms of this disorder?

Explain the site for marketing and site design purposes : Using the library, the Internet, and any other materials, prepare a PowerPoint presentation that outlines the following items

How is his state of nature different from hobbes : How is his state of nature different from Hobbes (Levithian)? What is he saying is the origin of property rights, and how does this differ from Hobbes' view?

Explain the contemporary theories and styles of leadership : veraging Organizational Behavior and Management to Maximize Business Success Presentation Due at Midnight EST

Develop an e-r diagram for the library database : Develop an E-R diagram for the library database. The relation schemas for the library database.

Type i and type ii errors issues : Is there anything we can do to measure the likekihood of tehse errors and thereby reduce the chance of these errors occuring?

Duties of people critical to the corporate process : Prepare a two to three page paper, following the APA guidelines, detailing the respective duties of people critical to the corporate process.

Informational article for a newspaper : Describe the differences between dispositional and evolutionary or biological personality theories. Discuss the strengths and limitations of dispositional and evolutionary or biological personality theories as they apply to behavior.

Effects and assistance in the educational system : Analyze the type of disorder. What are the specific disabilities associated with the disorder?

User Account

All Pages