Develop an e-r diagram for the library database

Assignment Help Database Management System

Reference no: EM13777726

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.

Implementation:

· Use Microsoft Office Access to create your database.

Reference no: EM13777726

Questions Cloud

External operating environments issues : Analyzes the structure of the organization and how this affects organizational performance

Importance of behavioral observation in cognitive psychology : How would you define cognitive psychology? Would you classify cognitive psychology as a hard science or a soft science? Why?

Criteria for establishing revenue recognition : In 2003, FASB and IASB met and established four criteria for establishing revenue recognition. To recognize revenue, which of the following conditions must be present?

Describe any possible impact on the parties : Describe any possible impact on the parties. Include a copy of the contract as an addendum to your evaluation. You will lose pointsif you do not include the contract

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)

Public relations influenced the direction of health care : What are some strategic goals that your organization can implement as it prepares for the next 25 years?

Write a journal on describe someone who is a hero to you : Write a journal on Describe someone who is a hero to you and explain why, Which character from a book would you most like to meet and why?

Drug treatment for adhd : Using the Argosy University online library resources, find at least two peer-reviewed journal articles that explain the effect of stimulant drugs (such as Adderall or Ritalin-amphetamine or methylphenidate) on the brains of those with ADHD.

Learn about a new culture or way of life : In 1-2 pages, describe a time when you had to learn about a new culture or way of life. (This could be another country, a different part of the USA, a new business, or a different school or family, and so on.)

User Account

All Pages