Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The CS Library is developing a new interactive library information system. The system contains 6 files with the following their record description: 1. Book file:

The CS Library is developing a new interactive library information system. The system contains 6 files with the following their record description:

1. Book file: Book Serial Number (BSN), Title, Author Name, Year, Number of copies, Location.

2. Periodicals file: Periodical Serial Number (PSN), Title, Year, Volume , Location, In/Out. 3. Patron File: Patron Identification Number (PID), Name, Phone, Loan Limit, Patron Type. 4. Loan File: BSN, PID, Copy Number, Issue Date, Return Date, Due Date.

Note that Date format is: MMDDYY. 5. Subject Index: Subject Code, List of related book Titles. 6. Author Index: Author Name, List of books.

Each patron (student or staff) input his/her PID to the system for verification before being allowed to request a loan. If the patron requests a book loan, the system first verifies the number of books on loan by this patron. If this number equals the Loan Limit the request is rejected. One periodical can be requested for internal use only. Therefore, the system should verify that the patron has no other outstanding periodical.

If the patron knows BSN (PSN), he can input it to the system to locate the required book (PSN). The system will then print an Issue Slip for internal library personnel to bring the book (periodical) to the library front desk personnel. Otherwise, if the item is not available an Unavailable Notice is printed for the patron. An accepted request will result in updating the Loan file or the Periodical file. If the patron does not know the required BSN, the system provides him with three search facilities where he can do a search by Title, by the Author, or by Subject. The search result is a list of matching books information. To return a book the PID and BSN (or PSN) are entered by the front desk library personnel and the corresponding file is updated.

The system is also used by the library manager for printing different types of reports. The first report type lists for each book the number of copies and the number of copies on loan. The second report shows for every book on loan the book information (BSN, Title, Author, Year), and, Name and Phone of the patron who has the book. Another type of reports lists information of all books on a given subject (using subject index) or by a given author (using author index).

The system allows addition and deletion of new books and periodicals by the front desk library personnel. Each time a new book is added, a subject code is entered to allow for updating the Subject Index. Also the number of copies can be changed for existing books.

Based on the above description of the interactive CS Library Information System:

a) Draw a Data Flow Diagram. Provide a narrative description of transformations (Processes) and a data dictionary for the External Entities, Data Flows, and Data Stores used in the DFD.

b) Draw a Use Case model. Give its tabular description that includes (UC#, Actor(s) Role, UC Name, and UC Goal & Rules).

c) Draw an Activity Diagram.

d) Draw a Sequence Diagram.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Datacasting How To Stream Databases Over The Internet

Authors: Jessica Keyes

1st Edition

007034678X, 978-0070346789

More Books

Students also viewed these Databases questions

Question

2 The main characteristics of the market system.

Answered: 1 week ago