Develop an e-r diagram for the library database

Assignment Help Database Management System

Reference no: EM13758561

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:
Find all students who have borrowed books.
Find all books name and their authors.
Any additional query you think it is useful.

Implementation:

Use Microsoft Office Access to create your database.

Deliverables:

A file contains the E-R diagram and the schemas (before and after normalization).
A file contains all SQL statements of creating tables, insert data.
A file contains SQL queries.
Submit all files on Blackboard by the due date.

Reference no: EM13758561

Questions Cloud

Extremely busy law firm specializing in litigation : Emmanuel and Petersen is an extremely busy law firm specializing in litigation. In order to keep up with their workload, they refuse to hire anyone as a secretary who is unable to type at least 65 words per minute. If a group of male applicants chall..

Five stages of the small business life cycle : Explain the strategies you would use to ensure your company is successful at each of the five stages of the small business life cycle. Explain risks and opportunities associated with each of the five stages of the small business life cycle.

Producer of servomechanisms has four major components : One of the industrial robots designed by a leading producer of servomechanisms has four major components. Components' reliabilities are .97, .96, .94, and .92, and all these components must function in order for the robot to operate effectively. Desi..

Describe some of the challenges linda brent faced : describe some of the challenges Linda Brent faced while she lived under Flint; there are many and they are varied in complexity.

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. Normalization of the relations (your relations should be in 4NF), SQL statements for creating all tables in your ERD

Write a paper on kindred by octavia e butler : Write a paper on Kindred by Octavia E. Butler.

Evidence as proof of the contract : Cresheim claimed that the oral contract was not binding because the contract was not in writing and the letter referring to the contract was not a contract but only a letter. Was the contract binding?

Draw an erd : Draw an ERD for the following problem with attributes, primary keys, cardinalities and participation constraints and specialization, if appropriate

Compare claude mckay and alice walkers narrative tone : Compare Claude McKay and Alice Walkers narrative tone, style, and theme. Please be sure to visit the lecture for more on each author.

User Account

All Pages