MIS605 Systems Analysis and Design Assessment 2: BookedBook.com Design

This report presents a comprehensive systems analysis and design for the BookedBook.com web application. It begins with a context diagram illustrating the interactions between the system and external entities like booklovers, content managers, and authors. The report then details a Level-0 and Level-1 Data Flow Diagram (DFD) to map out the system's processes, including registration, book searching, review and acquisition, scheduling advertisements, and administration. An Entity Relationship Diagram (ERD) is provided to visualize the relationships between entities such as Booklovers, Books, Content_Manager, and more. The report justifies the selection of data storage over file storage and includes a data dictionary to translate the ERD entities into a physical relational database design. Finally, the document demonstrates the database design in 3rd Normal Form (3NF) to ensure data integrity and efficiency. The report concludes with a list of references.

MIS605 Systems Analysis and Design
ASSESSMENT 2 BRIEF
Design specification
Student ID:
Student Name:
0

Table of Contents
Task 1: Context Diagram for BookedBook.com system...............................................................3
Task 2: DFD Level-0 Diagram for BookedBook.com system.......................................................6
Task 3: DFD Level-1 Diagram for BookedBook.com system.......................................................9
Task 4: ERD (entity relationship diagram) of BookedBook.com web page................................12
Task 5: Justification for Appropriate Data Storage of BookedBook.com....................................15
Task 6: Data dictionary to Show Physically relational database design.....................................16
3-NF data normalization form of BookedBook.com Database Design....................................19
References................................................................................................................................ 20
1

List of Figures
Figure 1: Context Diagram for BookedBook.com system.............................................................3
Figure 2: DFD Level-0 Diagram for BookedBook.com system.....................................................6
Figure 3: DFD Level-1 Diagram for BookedBook.com system.....................................................9
Figure 4: ERD (entity relationship diagram) of BookedBook.com web page..............................12
Figure 5: Physically relational database design.........................................................................16
Figure 6: 3-NF data normalization form of BookedBook.com Database Design........................19
List of Tables
Table 1: Action details of Context Diagram External Entities.......................................................4
Table 2: Description of different high-level procedures of BookedBook.com...............................7
Table 3: Explanation of Sub-sections of high-level procedures..................................................10
Table 4: Explanations of BookedBook.com ERD entities...........................................................13
Table 5: Advantages of Data Storage........................................................................................15
Table 6: Data dictionary to Show Physically relational database design....................................17
2

Task 1: Context Diagram for BookedBook.com system
Context diagram works as the technical approach to show relations between data flow and
system. The context diagram of bookedbook.com has 3 major elements such as system
process, data flow, and external entity (Valacich, George, & Hoffer, 2015). This is providing a
detailed description of factors and components that would be helpful for developers to design a
bookedbook web page.
Figure 1: Context Diagram for BookedBook.com system
Through this context diagram, it could be understood that booklovers, content manager, book
owner, author, and administration are different external entities that are performing various
actions with this bookedbook web page such as:
Table 1: Action details of Context Diagram External Entities
S. No. External Entities Actions of these Entities
1. Booklovers BookedBook system will help the booklovers for enrolling into the
system through the registration process and they can take the
3

benefits of the online book learning facility. Booklovers could
launch book based on their learning needs. When launching book
request will approve, then they can review & acquire the book.
Booklovers could interact with other booklovers by instant
messaging and chatting. They could organize meetings (face-to-
face and online meetings) with booklovers by enrolling for meet up
events.
2. Content
Manager
Through the bookedbook.com web page, he would approve the
request of launching the book for booklovers and request of book
advertisements for book authors.
3. Author BookedBook.com web page would allow authors for advertising
their books on bookedbook.com web page. There is no need for
authors to enroll in the system but they need to provide details of
the advertising book and fix the period for the advertisement.
When the content manager will approve this advertise request, the
author’s book advertises would be online on bookedbook.com
web page.
4. Book Owner Through bookedbook.com web page, he would receive a request
from booklovers for book acquisition. Then, the book owner will
meet with booklovers and exchange the books with him. After the
successful book acquisition, he would remove a book from the
available book (AB) list.
5. Administration Through the data analytics portal, the administration observes &
analyses every type of data information from this
bookedbook.com web page. For example, book exchanged rate,
mostly exchanged books, book rating, feedbacks and comments
of booklovers, etc. They would also observe booklover’s account
subscription details, if their subscription would be expired then
they would send renew mails to booklovers.
4

Task 2: DFD Level-0 Diagram for BookedBook.com system
In this task, DFD (data flow diagram) level-0 diagram is created to signify various levels
bookedbook.com web page system. And this diagram has included the different – different high-
level procedures and these are highlighted in inputs and outputs (by using an incoming and
outgoing arrow) & bubbles of this diagram (Chong & Diamantopoulos, 2020, P. 6). All these
high-level procedures of the DFD level-0 diagram is shown below:
5

Figure 2: DFD Level-0 Diagram for BookedBook.com system
Table 2: Description of different high-level procedures of BookedBook.com
S. No. High-Level Procedures Description of these procedures
1. 1.0 Registration By using this registration process, booklovers into the
system through the registration process and they can take
the benefits of online book learning facilities such as book
review, book acquisition, interaction with other booklovers,
6

and meetings with booklovers.
2. 2.0 Search Book By using this search book process, booklovers can search
the books based on their learning needs, then they would
request for launching the book through providing details of
books. Then, this request would transmit to the content
manager and he would approve the request based on
available books in the list.
3. 3.0 Review & Acquire
book
By using the review & acquire book process, booklovers
would review the books and they would provide their
comments and feedbacks about the books. They would
also rate the book that will help other users to find good
reading material books. Booklovers would acquire the
books by requesting for book acquisition that would
facilitate them to meet up with book owners and receive
books from book owners. After the successful book
acquisition, the book owner would remove a book from the
available book (AB) list.
4. 4.0 Schedule Advertise Schedule advertise procedure would allow authors for
advertising their books on bookedbook.com web page.
When the content manager will approve this advertise
request, then the author’s book advertise would be online
on bookedbook.com web page.
5. 5.0 Administration
process
By using this administration process, the administration
would observe & analyse every type of data information
that will be available in the bookedbook.com database
system. Different data analytics activities that could be
performed by administration are book exchanged rate,
mostly exchanged books, book rating, feedbacks and
comments of booklovers, etc. They would also observe
existing account subscription details of booklovers, if their
subscription would be expired then they will transmit renew
mails to booklovers for renewing their account
7

subscription.
8

Task 3: DFD Level-1 Diagram for BookedBook.com system
The main of this DFD (data flow diagram) level-1 is to provide the overall overviews of the fully
designed system. In this DFD level-1, the major processes of DFD level-0 are broken down into
the different sub-sections. DFD level-1 for bookedbook.com web page is created by breaking
the major high-level procedure of bookedbook.com DFD level-0 in this task that is shown below.
BookedBook.com DFD level-1 has also identified the different data storages that are utilized by
the main procedures of a system (Hapsari & Priyad, 2017, P. 66-71).
Figure 3: DFD Level-1 Diagram for BookedBook.com system
9

10

The description of different identified sub-sections is shown below in the table format:
Table 3: Explanation of Sub-sections of high-level procedures
High-Level
Procedures
Sub-sections of high-
level procedures
Explanation of these sections
1.0 Registration 1.1 Add registration
Information
When booklovers would enter the enrolment information,
then this information would be verified by the system to
check the duplication of registration information in the
user directory.
Then, the server system of bookedbook.com system
would process these data for storage and transfer these
data to admin so that they can store these data into
Bookedbook.com system.
Then, the system would transmit the successful
registration on the registered mail id of booklovers.
2.0 Search Book 2.1 Launch the book When booklovers would enter the details of books, then
the system would check the availability of books in the AB
(available book) database. And if books will be available
in the list, then the book would be displayed the in-front of
the booklovers.
Then, booklovers would launch the books by using the
launching book facility or option. After that, this request
would transmit to the content manager and he would
approve the request based on available books in the list.
Then, the system would send the confirmation mail for
launching book requests and now booklovers can
perform the review and acquire operations.
3.0 Review &
Acquire book
3.1 Book Acquire
process
When booklovers would review the books and provide
their comments and feedbacks about the books. Then,
these data would be stored in the administration
database and these details would be used by the admin
department to observe the book exchanged rate, mostly
11