A university library database records

Assignment Help Database Management System
Reference no: EM13168180

A university library database records information about books; for each book, it records the book isbn number

(which is unique), and the book name. In addition, it records which books have been checked out : the

information it keeps for the books which have been checked out is the student id of the student who checked it

out, and the date on which the book was checked out. Some books may not be checked out. You can assume

that there is only one copy of each book.

Each of the following situations concerns how we capture the information in dierent situations.

Situation 1:

For each book, we only keep track of the student who has currently checked out the book i.e. we don't keep

track of who checked out the book in the past.

Situation 2:

For each book, we keep track of the student who has currently checked out the book and we also keep track

of who checked out the book in the past. Here you can assume that no student ever checks out the same

book more than once.

Situation 3:

For each book, we keep track of the student who has currently checked out the book and we also keep track

of who checked out the book in the past. Here it is possible that the same student has checked out the

same book more than once; for example, once on June 4, 2013 and another time on July 19, 2013. You can

assume that no student can check out the same book twice on the same day.

Reference no: EM13168180

Questions Cloud

Allows a user to select a favorite basketball team : Write an application that allows a user to select a favorite basketball team from a list box. Include at least five teams in the list, and display the chosen team in a text field after the user makes a selection. Save the file as JBasketball.java. :
Your company has assigned you the task : Your company has assigned you the task of evaluating its computer networks. You are to write a memo covering 15 points on which you will evaluate the technology, connectivity, and functioning of the company's computer networks
How to select the primary key : How to select the primary key from the candidate keys? How do foreign keys relate to candidate keys? provide examples from either your workplace or class assignments
Ohio phonebook has gotten mixed up : In an accident, the Ohio phonebook has gotten mixed up. The names are now really out of order. You and your enthusiastic, but naive, assistant Carl must fix the problem. No one can use the phonebook while you are sorting it, so every extra second of ..
A university library database records : A university library database records information about books; for each book, it records the book isbn number (which is unique), and the book name. In addition, it records which books have been checked out
Program that computes and prints the value of 6!/5! using : Write a Java program that computes and prints the  value of 6!/5! using Scanner.
The method takes an array : The method takes an array of integers and returns true if there exists any item in the array that satisfies a specified condition. For instance, the following code fragment:
Write a class volumeofbox that calculate the volume : write a class VolumeOfBox that calculate the volume by this formula : length * breadth *
Implement one class called parkingmeter : implement one class called parkingmeter, that is a simple model of a coin operated parking meter

Reviews

Write a Review

Database Management System Questions & Answers

  Expressions in tuple relational calculus and domain relation

Consider the relational database described in Problem Give expressions in tuple relational calculus and domain relational calculus for each of the following queries: Find all the companies that have offices in all the cities in which company C2..

  Create an e-r diagram

You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing.

  Create a data warehouse conceptual design

Create a Data Warehouse conceptual design using Star Schema Modelling and document all steps during the design process

  Create application owner and stored in schema

One of the tenets of database development is to never permit developers to create or own objects during development. All objects are created by application owner and stored in that schema.

  Explain use of sequential file over database

Explain these situations. When would the database be more beneficial than sequential file? Is it possible for two kinds of permanent storage to be used interchangeably?

  Create and run the following sql queries

Create and run the following  sql  queries and submit the screen shot of your result. Also submit the file lab_06_03. sql

  Create a crow''s foot erd using a specialization hierarchy

Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms

  Completing transaction using sql

Write down the complete transaction using SQL.

  Database modeling and design

Database Modeling and Design: A complete table diagram. Transform model to tables, include all attributes and keys.

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Systems analysis and database design

Based on the information in the Bike Mania case study, use a suitable CASE tool or drawing package to draw up a set of diagrams showing the current physical view of the systemusing the unified modeling language (UML 2.0) notation

  What is the two-phase locking protocol

What is the two-phase locking protocol and what is the strict two-phase locking protocol? What is the rigorous two-phase locking protocol? What benefit does strict two-phase locking protocol provide? What benefit does rigorous two-phase locking pr..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd