Information System Design: Books for All Library - CSE1ISX Report

This report presents the design of an information system for the 'Books for All' library, adhering to the CSE1ISX course requirements at La Trobe University. It includes a context diagram, level 0 data flow diagram, and a system prototype featuring an Entity Relationship Diagram (ERD) and data dictionary. Functional requirements such as registration, login, book search, borrowing, and report generation are defined, along with non-functional requirements like security, availability, and usability. The report details the data structure for members and books, outlining fields like member ID, name, email, and book title, ISBN, and author. This comprehensive design aims to provide an efficient and secure system for managing library resources and member interactions.

Running head: INFORMATION SYSTEMS
Information System
Name of the System
Name of the University
Author’s note:

1INFORMATION SYSTEMS
Table of Contents
Part A: Context and Data Flow Diagrams.......................................................................................2
Task 1: System Requirements.....................................................................................................2
Task 2: Context Diagram.............................................................................................................4
Task 3: Level 0 Data Flow Diagram............................................................................................5
Part B: System Prototype.................................................................................................................7
Task 1: ERD................................................................................................................................7
Task 2: Data Dictionary...............................................................................................................7
Bibliography:.................................................................................................................................11

2INFORMATION SYSTEMS
Part A: Context and Data Flow Diagrams
Task 1: System Requirements
Functional Requirements: The functional requirement define the purpose of the system
and what processes it will complete. The functional requirements of the system are as following.
i. Registration: The potential customer of Books for All has to register to the
system to borrow books. In order to register into the system, the customer have to
provide their personal details like first name, last name, email address, telephone
number, address and date of birth to the system. Along with their personal details,
the system will ask the customer to enter the user name and password. The
password should be of eight character long and include upper-case letter and
numbers. During the registration process, the credit verification is also done.
Credit card verification is essential as system will charge the customer by
deducting amount from back account to which the card belongs. In order to store
credit card details, the customer will provide their credit card details to complete
the registration process. After completion of the registration an auto generated
unique membership id will be given to the customer.
ii. Login: After successfully completing the registration process, the customer can
login to the system using the same username and password they provided during
registration. Only after successfully completing the login process, the member can
look for books in the system.
iii. Search Books: The members can use the system for searching books. The system
will show the books that are stored in its database. For a book that is not stored in

3INFORMATION SYSTEMS
the database, the system will show an error message that requested book is not
available. Member can also look for books using the catalogs. Books can be
searched by author, publication and genre.
iv. Borrow Books: The members can borrow books from system directly. The digital
copies of are borrowed and after rent period is over, the books will expire from
member device. For borrowing books, the member will just click on the rent.
After that the system will automatically download the digital copy of the book
into member’s device.
v. Reports: The system will also generate reports based on the rents for a particular
month. These reports will be accessed by Helen only.
Non-functional requirement: The non-functional requirement determine the coding
quality and how well the system will perform. The non-functional requirements are as following.
i. Security: The system needs to be highly secure as it will store the card details of
the member. The system must be able to prevent any malicious activity and
servers should be capable of preventing DDoS attack.
ii. Availability: The system must provide services to the potential customers and
members 24*7. The members can use the system to borrow books anytime.
iii. Usability: As the system can be used by any age group, the system usability must
be effective enough to provide everyone same quality of service. It should have a
great navigation and learnability feature.

4INFORMATION SYSTEMS
Task 2: Context Diagram

5INFORMATION SYSTEMS
Task 3: Level 0 Data Flow Diagram
Task 4: Decision Table
Conditions
Member is not logged in T F
Member has account F T
Actions
Ask member to login T
Ask member to register T
Conditions
Ten books has been borrowed T F

6INFORMATION SYSTEMS
Actions
Allow borrow more books F T
Conditions
Searched books is available T F
Ten books has been borrowed F T
Actions
Allow borrow more books T F

7INFORMATION SYSTEMS
Part B: System Prototype
Task 1: ERD
Task 2: Data Dictionary
Member Table:

8INFORMATION SYSTEMS
Data
element
name
Alias Type Lengt
h
Defaul
t value
Acceptable
values
Descriptio
n and
comments
member_i
d
none INT 11 None 11 The
primary
key of the
table
first name firstName varcha
r
200 None James The first
name of the
member
last name lastName varcha
r
200 None Pattick last name
of the
member
email
address
emailAddress varcha
r
200 None [e-mail]
m
email
address of
the
member
telephone
number
telephoneNumbe
r
INT 11 None 22235455 Contact
number of
the
member
address varcha
r
200 None Main Street Residential
address of

9INFORMATION SYSTEMS
the
member
date of
birth
DOB DATE None 12-02-1993 date of
birth of the
member
username none varcha
r
200 None james@1993 username
of the
member
account
password none varcha
r
200 None James1234 password
of the
member
account
Books Table:
Data
element
name
Alias Type Lengt
h
Defaul
t value
Acceptable
values
Descriptio
n and
comments
book_id none INT 11 None 11 The
primary
key of the
table
title firstName varchar 200 None I.T. The tile of

10INFORMATION SYSTEMS
the book
ISBN None INT 11 None 23456789 last name
of the
member
author_nam
e
None varchar 200 None Stephen King The name
of the
author who
wrote the
book
publisher None varchar 200 None Penguin The name
of the
publisher
who
published
the book
publish_year None DATE None 12-02-1993 The year in
which the
book was
published,
the current
version
system us
lending

11INFORMATION SYSTEMS