Database for a library of a university

Assignment Help Database Management System

Reference no: EM13758052

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: EM13758052

Questions Cloud

What are your personal feelings of group unification : What are your personal feelings of group unification and responsibilities? How important are these attributes? Group Diversityand What makes Successful teams?

Describe the technology required to use these tools : Write a paper explaining the business uses of cloud computing and Web 2.0. Be sure to address the following in your assignment: Describe the technology required to use these tools

Influence the chief executive officer : Discuss how you can influence the chief executive officer (CEO) to consider expansion and new technology.

Why is the interest rate on a security sold : Why is the interest rate on a security sold by a city government usually less than the interest rate on a security sold by a corporation if both have comparable default risk?

Database for a library of a university : 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

Analyze and critique production using theatrical terminology : Analyze and critique the production, using theatrical terminology, not merely "liking or disliking" the play.

Write summary of the process to overcome barriers : Write a summary of Cultural Barriers & Process to overcome barriers.

Customer relationship management : Define the given terms with example: Wireless, Social Media, Customer Relationship Management (CRM)

Financial statements related to cash and cash equivalents : Write a 700- to 1,050-word paper analyzing the disclosures contained within the notes to the financial statements related to cash and cash equivalents, receivables, and inventories. Include a list identifying the components of the organization's c..

User Account

All Pages