Analysis, Design, and Implementation of a Book Rental System Project

This project focuses on the National Bookstore Online Book Rental System, outlining its requirements, data flow, and system prototypes. The assignment begins by detailing the system requirements, including functionalities such as book searching by various criteria (title, genre, etc.), user and book information storage, credit card processing, rental limits, and invoice generation. It then presents a context level diagram and a level-0 Data Flow Diagram (DFD) to illustrate the system's processes. A decision table is also included to define conditions and actions. The second part of the project provides a system prototype, including an Entity Relationship Diagram (ERD) to model the database structure, showing entities like users, books, and rentals, and their relationships. Finally, a data dictionary is provided, detailing the attributes of key data elements such as user name and password with their characteristics.

Running head: NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
Name of the Student
Name of the University
Author Note

1NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
Table of Contents
PART A – Context and Data Flow Diagrams.................................................................................2
Task 1: System Requirement.......................................................................................................2
Task 2: Context Level Diagram...................................................................................................3
Task 3: Level-0 DFD...................................................................................................................4
Task 4: Decision Table................................................................................................................5
PART B - System Prototype............................................................................................................6
Task 1: Entity Relationship Diagram (ERD)...............................................................................6
Task 2: Data Dictionary...............................................................................................................7

2NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
PART A – Context and Data Flow Diagrams
Task 1: System Requirement
System Requirements are the necessary configurations of the system and their
functionalities in order to achieve the goal of the system. The functionalities of the system are
defined as different objectives of the system which is collectively said as the aim of the system.
Some of the requirements of the National Bookstore Online book rental store system, are
described below:
a. All the members of the system should be able to search the books by the file size, book
title, genre, type and year of release.
b. Each book is assigned a unique identification number which is the BookID in ERD.
c. The system should be able to store user information, rental information, book
information, credit card information and staff meeting information.
d. The system should be able to charge user from their credit cards while renting.
e. The maximum limit of the books for rent is 10 and for rental period is 30 days.
f. The system should be able to send invoice to the registered email of the users.
g. The system should be able to generate summary of all the reports from rental history.

3NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
Task 2: Context Level Diagram
Figure 1: Context level Diagram
Source: Created by author

4NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
Task 3: Level-0 DFD
Figure 2: 0-level Data Flow Diagram
Source: Created by author

5NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
Task 4: Decision Table
Conditions 1 2 3 4
No of rented books >10 Y Y N N
Permission to charge from
card Y N Y N
Action
Allow renting X X
Allow Payment X X

6NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
PART B - System Prototype
Task 1: Entity Relationship Diagram (ERD)
Figure 3: Entity Relationship Diagram
Source: Created by author

7NATIONAL BOOKSTORE ONLINE BOOK RENTAL STORE
Task 2: Data Dictionary
Element Description User Name Password
Data Element Name UserName Password
Alias None None
Type varchar varchar
Length 50 20
Default Value null null
Acceptable values Upper-case letter, lowercase
letters, number and symbols.
Upper-case letter, lowercase
letters, at least one number
and one symbol.
Description and comments The data element Username
is defended from the email
address of the user and stored
in the system.
User can create their own
password by fulfilling the
validation criteria of
acceptable values.