User Account

All Pages

EER models, Database Management System

Assignment Help:
Ask question #MinimThe Georgia Tech Library (GTL) has approximately 16,000 members, 100,000 titles, and
250,000 volumes (an average of 2.5 copies per book). About 10 percent of the volumes are out on
loan at any one time. The librarians ensure that the books that members want to borrow are
available when the members want to borrow them. Also, the librarians must know how many copies
of each book are in the library or out on loan at any given time. A catalog of books is available online
that lists books by author, title, and subject area. For each title in the library, a book description is
kept in the catalog that ranges from one sentence to several pages. The reference librarians want to
be able to access this description when members request information about a book. Library staff
includes chief librarian, departmental associate librarians, reference librarians, check-out staff, and
library assistants.
Book can be checked out for 21 days. Members are allowed to have only five books out at a
time. Members usually return books within three to four weeks. Most members know that they have
one week of grace before a notice is sent to them, so they try to return books before the grace
period ends. About 5 percent of the members have to be sent reminders to return books. Most
overdue books are returned within a month of the due date. Approximately 5 percent of the
overdue books are either kept or never returned. The most active members of the library are
defined as those who borrow books at least ten times during the year. The top 1 percent of
membership does 15 percent of the borrowing, and the top 10 percent of the membership does 40
percent of the borrowing. About 20 percent of the members are totally inactive in that they are
members who never borrow.
To become a member of the library, applicants fill out a form including their SSN, campus
and home mailing addresses, and phone numbers. The librarians issue a numbered, machinereadable
card with the member’s photo on it. This card is good for four years. A month before a card
expires, a notice is sent to a member for renewal. Professors at the institute are considered
automatic members. When a new faculty member joins the institute, his or her information is pulled
from the employee records and a library card is mailed to his or her campus address. Professors are
allowed to check out books for three-month intervals and have a two-week grace period. Renewal
notices to professors are sent to their campus address.
The library does not lend some books, such as reference books, rare books, and maps. The
librarians must differentiate between books that can be lent and those that cannot be lent. In
addition, the librarians have a list of some books they are interested in acquiring but cannot obtain,
such as rare or out-of-print books and books that were lost or destroyed but have not been
replaced. The librarians must have a system that keeps track of books that cannot be lent as well as
books that they are interested in acquiring. Some books may have the same title; therefore, the title
cannot be used as a means of identification. Every book is identified by its International Standard
Book Number (ISBN), a unique international code assigned to all books. Two books with the same
title can have different ISBNs if they are in different languages or have different bindings (hardcover
or softcover). Editions of the same book have different ISBNs.
The proposed database system must be designed to keep track of the members, the books,
the catalog, and the borrowing activityum 100 words accepted#

Related Discussions:- EER models

Example of alter table command, Example - ALTER TABLE emp MODIFY (empno NUM...

Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

IT Assignmnet, i need help for assignment ..

i need help for assignment ..

Define the query optimisation, Define the Query optimisation The query ...

Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica

Issues relating to the design of the physical database files, The issues re...

The issues relating to the Design of the Physical Database Files Physical File is a file as stored on the disk. The major issues relating to physical files are:  •      Cons

Describe object relational model, Describe Object Relational model ? O...

Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit

Using relational algebra which query finds customers, Using Relational Alge...

Using Relational Algebra which query finds customers, who have a balance of over 1000 ? Using Relational Algebra Π Customer_name( σ balance >1000(Deposit)) is query to find cu

Define two phase commit, Define Two phase commit Two phase commit: To m...

Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran

What are the comparison operator in sql, What are the comparison operator i...

What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

Type of views-data control, Type of views :  Simple views and Difficult ...

Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

What do you understand by data ware house, Question 1: Define the term ...

Question 1: Define the term business intelligence tools? Briefly explain how the data from one end gets transformed into information at the other end? Definition Exp

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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