System Analysis and Design for IndyFlix's Business

The assignment covers the system analysis process and system design process for the current system of the organization. It will help to remove the inconsistencies from the current system while building the proposed new system.

Task Part A
Executive Summary
The assignment is about the system analysis and design process for the IndyFlix’s business. The
assignment covers the system analysis process and system design process for the current system
of the organization. It will help to remove the inconsistencies from the current system while
building the proposed new system.
1

Table of Contents
Introduction......................................................................................................................................3
Company Background.....................................................................................................................4
Documentation.................................................................................................................................5
Data Dictionary............................................................................................................................5
Process Description.....................................................................................................................8
Event Table......................................................................................................................................9
Context Diagram............................................................................................................................11
DFD Level 0..................................................................................................................................12
DFD Level 1..................................................................................................................................13
ER Diagram...................................................................................................................................14
References......................................................................................................................................15
2

Introduction
From a business’s perspective, they want to gain competitive advantages and want to become
profitable. Information and communication technologies have become an indispensable part of
businesses. The technologies are always evolving. So, the businesses need to upgrade their
existing systems to stay ahead in the competition and to utilise the benefits of the technologies.
The process of system development and implementation is a complex one (Wang & Wang
2012). It has multiple phases. System analysis and design is such an early phase in a system
development and implementation project. It helps to understand the current system being used,
and finding out the loopholes and inconsistencies in the current system. The knowledge gathered
from the system analysis and design process helps in developing the system models and that in
turns help the developers in the later stage (Buede & Miller 2016). Based on the quality and
accuracy of the work done in the system analysis and design phase, the success of the project on
developing a new information system depends(Dennis, Wixom & Roth 2014).
The purpose of the work is to explore the business case, operations and processes of the
IndyFlix’s business with the help of various system analysis and design techniques and
methodologies. The once profitable business is suffering from some issues and challenges. They
need to implement a new information system that will help them to run their business smoothly
and consistently in future. The business is in a growing phase and has opened multiple centres. If
they don’t integrate all the business units with the help of information and communication
technologies, then in future they may be in trouble to manage the business at a large scale.
3

Company Background
IndyFlix is a growing company that sales and rents moviles made by independent movie makers.
It is running successful over the years and have generated significant revenue in the times of
streaming videos. There are small outlets of the business from where the customers can rest or
purchase a movie. Otherwise, there is a website that allows customer to check the catalogue and
select movies. The customers need to either send a purchase order form dully filled up or must
send a rent request. An attendant will check the request and availability of the requested titles. It
may happen that the stock of one title is not available in one store or outlet, then they check the
stocks of the other outlets and may bring the title from other stores. All data are stored locally at
the outlets. Only the accounts data are sent to HQ where an accounts staff check the data.
Customers can make payment using different modes. The details of the payment process is out of
the scope of the system (Chiang, Siau & Hardgrave 2012).
A customer may take a loan and return it on time. Otherwise there will be fines added on the
loan. If there is a due from a customer, the system notifies through call or email. Or staffs may
go to the given address for the titles. A customer can request a reserve on a title and may
purchase a title.
The management and administration is also interested in generating many manual reports on the
performance of the business, sales persons, and sales and so on (Davis 2014).
The functional requirements are the functions performed by the current system. Most of the
functions are manual and that requires some help from some computerised systems.
 A supplier sends movie titles and invoice
 A new customer submits customer registration form
4

 Customer receives a borrower card
 Customer places a purchase order
 Customer places a rent order
 Attendant checks stocks of titles
 Staff makes supply purchase order
 Customer requests a reserve on a title
 Admin generates reports
 Staff notifies customer for due
 Customer searches catalogue
The non-functional requirements are,
 Security
 Access control
 Portability
 Reliability
Documentation
The documentation section covers the logical descriptions of the DFDs in terms of data
dictionary and the process descriptions.
Data Dictionary
A logical data dictionary works like a metadata repository. There should be a centralized data
repository containing the data about all data of the system (Kendall & Kendall 2013). A logical
data dictionary is important for an organization as it allows the organization to describe their data
in terms understandable to their logical data models (Chiang, Siau & Hardgrave 2012).
5

The logical data dictionary of the current system of the organization is given below,
Table Attribute Data type Key
Customer custID Integer Primary key
custName Varchar(n)(Langer 2001)
where n > 0
Address Varchar(n) where n > 0
email Varchar(n) where n > 0
phoneNumber Varchar(n) where n > 0
mobileNumber Varchar(n) where n > 0
drivingLicense Varchar(n) where n > 0
medicareNum Varchar(n) where n > 0
passportNum Varchar(n) where n > 0
storeID Integer Foreign key
Items itemID Integer Primary key
movieName Varchar(n) where n > 0
rentPrice Decimal (m,n) where m, n> 0
purchasePrice Decimal (m,n) where m, n> 0
sellingPrice Decimal (m,n) where m, n> 0
releaseDate Date
duration Decimal (m,n) where m, n> 0
genre Varchar(n) where n > 0
Supplier suppID Integer Primary key
6

supplierName Varchar(n) where n > 0
suppAddress Varchar(n) where n > 0
Store storeID Integer Primary key
Address Varchar(n) where n > 0
phoneNumber Varchar(n) where n > 0
Email Varchar(n) where n > 0
Staff staffID Integer Primary key
staffName Varchar(n) where n > 0
Role Varchar(n) where n > 0
storeID Integer Foreign key
PurchaseOrder orderID Integer Primary key
orderDate Date
orderQty Integer
deliveryDate Date
Payment Decimal (m,n) where m, n> 0
paymentDate Date
custID Integer Foreign key
staffID Integer Foreign key
RentOrder rentID Integer Primary key
startDate Date
EndDate Date
actualReturnDate Date
dailyFine Decimal (m,n) where m, n> 0
7

renewalStatus Varchar(n) where n > 0
custID Integer Foreign key
Process Description
The short descriptions of the processes from the level 1 DFD are,
 Customer registration
A customer downloads the registration form, and then submits the dully filled up form with
documents supporting the identity of the customer and other relevant information. The attendant
on the behalf of the company, verifies the documents and the identity of the customer. When the
identity is successfully verified then they prepare a contract form and that is sent to the customer.
The customer signs and returns the form. Then a borrower card issued for the customer and sent
to the customer. The process also covers the payment made by the customers and the bills sent to
the customers (Kenneth 2016).
 Supply maintenance
The suppliers are sent the purchase order and they sent backs the supplies and the invoice. The
supplies are then arranges into the stock and the stock details are updated.
 Report generation
The management prepares and generates a lot of different types of reports based on the
performance of the business, the loans, dues and so on.
 Movie rental and purchase
8

A customer can place a movie purchase or rental request. The purchase or rental order can be
downloaded from the website, the customer searches through the catalogue and then selects the
titles to purchase by filling the purchase form or the rental form and then submission of the same.
the staff checks whether the titles are available or manages from other stores, fixes a delivery
schedule and gives it back to the customer. If a customer has rented a title and then the loan is
not cleared then the staffs can notify the customers or can send notification to the customers
through email.
 Stock checking
The stores check the stocks at the other stores to see the stocks at the other stores. It involves
asking the staffs of the other stores and checking manually whether they have the stock available.
Task Part B: Modelling for the current system
Event Table
An even table shows the major events of a system and the even table for the current system of
the IndiFlix is given below.
Event Trigger Initiator Use Case Recipient
A supplier sends
movie titles and
invoice
Purchase order
sent to the
supplier
Supplier Supply Movies IndyFlix
A new customer
submits customer
registration form
Customer
registration form
submitted
Customer Verify Customer Attendant
9

Customer
receives a
borrower card
Borrower card
created
Attendant Get Card Customer
Customer places
a purchase order
Purchase order
placed
Customer Place order Staff
Customer places
a rent order
Rent order placed Customer Request Rent Staff
Attendant checks
stocks of titles
Stock details are
fetched
Attendant Check Stock Stores
Staff makes
supply purchase
order
Purchase order is
created
Staff Order Supply Supplier
Customer
requests a reserve
on a title
A reserve request
has been
submitted
Customer Request Reserve Attendant
Admin generates
report
Data for report
are collected
Staffs Generate report admin
Staff notifies
customer for due
Customer has due
loan
Staff Notify for Due Customer
Customer
searches
catalogue
Customer has
initiated a search
process
IndyFlix Search
Catalogue
Customer
10

Context Diagram
11

DFD Level 0
12

DFD Level 1
13

ER Diagram
14

References
Davis, W. S. (2014). Business Systems Analysis and Design: Wadsworth Publishing Company.
Langer, A. M. (2001). Analysis and Design of Information Systems: Springer.
Buede, DM & Miller, WD 2016, The engineering design of systems: models and methods, John
Wiley & Sons.
Chiang, R, Siau, K & Hardgrave, BC 2012, Systems Analysis and Design: Techniques,
Methodologies, Approaches, and Architectures, M.E. Sharpe.
Davis, WS 2014, Business Systems Analysis and Design, Wadsworth Publishing Company.
Dennis, A, Wixom, BH & Roth, RM 2014, Systems Analysis and Design, Wiley.
Kendall, K & Kendall, J 2013, Systems Analysis and Design, Global Edition, Pearson Education
Limited.
Kenneth, L 2016, Management Information Systems: Managing The Digital Firm, 11/E, Pearson
Education.
Langer, AM 2001, Analysis and Design of Information Systems, Springer.
Wang, S & Wang, H 2012, Information Systems Analysis and Design, Universal-Publishers.
15