The University library system will record the books owned by the library as well as any new books purchased and put into circulation

BIS Analysis and Design

Assignment 2

Ittihad University

College of Management and Information Systems

Answers of Assignment 2

Draw a DFD for the following cases1. Customer places sales orders. The system checks for availability of products and updates sales information Context Diagram:

Diagram 0:

2. Company receives applications. Checks for eligibility conditions. Invites all eligible candidates for interview. Maintains a list of all candidates called for interview. Updates the eligibility conditions as and when desired by the managementContext Diagram:

Diagram 0:

3. Library Information System: The University library system will record the books owned by the library as well as any new books purchased and put into circulation. Before someone can borrow a book, he or she must show a valid ID card that is checked to ensure that it is still valid against the student files maintained by the registrars office (for student borrowers), the faculty/staff files maintained by the personnel office (for faculty/staff borrowers), or the librarys own guest file (for individuals issued a guest card by the library). The system must also check to ensure the borrower does not have any overdue books or unpaid fines before he or she can borrow another book. If no fines or overdue books are found, the book is checked out. The system should record who has borrowed what book and when it is due back. The borrower is also told the due date. Books can only be checked out for two weeks. When a book is overdue, the information about the book and the person who checked it out is added to an overdue file. Every Monday, the library prints and mails postcards to those people with overdue books. If a book is overdue by more than one month, a fine will be imposed and a librarian will telephone the borrower to remind him or her to return the book.Context diagram: . etc

Draw an Entity Relationships diagram for

4. An airline reservation is an association between a passenger, a flight, and a seat. Select a few pertinent attributes for each of these entity types and represent airline reservation in an E-R diagram.

5. A library has many books and many readers. One reader can borrow many books; one book can be borrowed by many readers at different time. If a book is lent to a reader, the lending date and return date must also be recorded. Attributes about book and reader are given below:

a. Book: book number, book name, author, price, publishing date, status;

b. Reader: card number, reader name, gender, address, phone number;

Draw an entity relationship diagram about book and reader, if necessary; add associative entity to represent the relationship between book and reader.

Response

Sales orders

0

Process orders

Customer

Sales orders

Response

Customer

Checks for availability

1

2

Updates sales information

D1

Stores

Sales orders

New stores

Stores availability

Sales orders

Response

Applications

0

Process applications

Applicants

New conditions

Reader

0

Borrow books

Current conditions

Current conditions

Conditions

D2

3

Updates conditions

New candidates list

Eligible list

4

Maintains list

List of all candidates

D1

Invitations

Eligible list

2

Invites eligible

Applications

1

Checks conditions

Applicants

ID card

Book

Due date

Postcards

Telephone call

Books

Books information

Flight

M

1

Flight#

Flight-date

Departure time

Arrival time

Departure airport

Arrival airport

N

M

Have

Reserve

Seat#

Class

Seat

Passport#

Name

Nationality

Address

Passenger

N

M

Borrow

Lending date

Card number

Reader name

Gender

Address

Phone number

Reader

Number

Book name

Author

Price

Publishing date

Status

Book

Return date

4/17/2008

5/6