MIS605 Systems Analysis and Design

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