Report on Business Systems Analysis and Design for an Online Bike Shop

This report provides a detailed analysis and design of a business system for an online bike shop. It begins with an executive summary, followed by an introduction that outlines the scope of the project. The core of the report focuses on various tasks, including the creation of data flow diagrams using SSADM notation to visualize information flow within the system. A comprehensive data dictionary is provided, listing all data items shown in the diagrams. The report also includes an entity-relationship diagram to illustrate relationships between different entities, as well as entity life histories for each entity. Furthermore, it presents a logical data structure, identifying main data entities and their specific relationships. The report concludes with a summary of the findings and a list of references, including books and journals that support the analysis and design of the bike shop's business system. The report covers aspects such as customer, stock, supplier, order, item, and invoice management within the bike shop's operations.

BUSINESS SYSTEMS ANALYSIS AND
DESIGN

Executive Summary
The process of business system and analysis design includes to analyse the information system to
meet the requirement of particular database. It has developed and design the database that help
for managing and controlling the online Bike System. This design system has managed the entire
operations to sell and purchased product by using online bike shop. This system has designed for
solving the problem related the bike and also helps for collecting all the records of every client in
effective manner.

Table of Contents
INTRODUCTION...........................................................................................................................3
TASKS.............................................................................................................................................3
Data flow diagram of logical design by using the SSADM Notation.........................................3
Data dictionary listing all the data items shown in the data flow diagram set ...........................6
Entity relationship diagram:........................................................................................................7
Entity life histories of each of entities.........................................................................................9
A logical data structure and also identifying the main data entities and their specific
relationships..............................................................................................................................10
CONCLUSION..............................................................................................................................15

INTRODUCTION
Business analysis and system design is a process or method of research on particular field
to identifying the need and requirement of enterprises. An effective solution of business process
to includes the software system that consist of different process for improvement and
development. This report will discuss about the entire processing of bike shop. It can be
representing in the form of data flow diagram. This diagram contains the information regarding
the entities and data set that consist of data in proper manner. This assignment will describe the
listing of data dictionary whereas all he data item representing in the form of DFD set.
Furthermore, it will describe the entity life and histories in each core entities (Diarmuid, Pigott
and Valerie, 2011). At last, it discusses about the logical structure that identifying the main data
entities and their specific relationship between the data sets.
TASKS
Data flow diagram of logical design by using the SSADM Notation
A data flow diagram is based on the graphical representation of flow of information with
the help of information system. It is modelling process that used for the data visualization in the
processing. DFD shows different kind of information that input and output from the system. It is
advanced system that always maintain the entire model and structure of information in proper
manner. Data flow diagram is mainly useful in the documentation that explore the high level of
design in the terms of data flow (Bing‐hai and Wang, 2015).
Data flow diagram is contain the different processes and other two external entities or
data stores. It doesn't require for designing the diagram that governs to choose the correct
position of shapes that implement in the data flow diagram (Hao and Giunchiglia, 2015). The
performance and maintenance is process that takes for inspection where data store as input and
also provide the customer bill. All the details of stored in the work stores.
Data flow Diagram:

0 level DFD-
1 level DFD
Illustration 1

2 level DFD
According to the diagram, it can be concluded that there are two different level of
diagram that represent in specific manner. In 0 level DFD, Supplier can provide the new product
of cycle according to their demand. It is mainly focused on to supply the inventory product to the
customers. This is the actual data flows in 0 level DFD.
In 1 level DFD, customer connect with the shop to repair their bicycle and also connect
with the mechanic. This flow data is representation for maintenance of overall role of consumer
in the bike shop.
Illustration 3

Data dictionary listing all the data items shown in the data flow diagram set
A Data dictionary is basically collection of data objects and different item in the data
mode. This is the beneficial for programmer to create data flow diagram for analysing the system
object in effective manner. Customer directly interact with object to identify the relationship
between another objects. This process is called data modelling and creating effective relationship
with the objects. In data flow diagram, there are different types of entities and having specific
attributes such as
 Customer
 Stock
 Supplier
 Order
Theses are important entities that representing the data flow diagram where all the informations
are performed different operations and functions in effective manner. The data dictionary is
basically used to store and create the location, format for particular data storage. Data dictionary
is used to easily retrieve that data that already applicable in the application. It is described with
the help of entities and their relationship between them (Byron Dangerfield and Morris, 2016).
Customer is entity in the data flow diagram that contain different types of attributes such as
Customer_id, Customer_name, Customer_address, Customer_phone number, Customer_email
address etc. All the details contain the customer table.

Data Dictionary:
Entities Attributes Relationships
Customer  Customer id (PK)
 customer title
 customer name
 customer address
 customer city
One to many
Stock  Stock id (PK)
 supplier no (FK)
 item serial no
 item_description
 wholesale rate
One to one
Supplier  Supplier no (PK)
 supplier name
 supplier address
 supplier city
 supplier postcode
 supplier phone no
One to many
Order  Order id (PK)
 order date
 order delivery date
 customer id (FK)
One to many
Item  Item id (PK)
 item name
 orderitem date
 supplier no (FK)
One to many
Invoice  Invoice id (PK)
 invoice date
 invoice total
Many to many

 customer id (FK)
 item id (FK)
Stock location quality  Stock no
 stock item location
 stock quantity
 reorder level
 order id
One to one

Entity relationship diagram:
Entity relationship diagram is a type of relationship between the different entities set that records
all the information in the form of database system. An entity is the context object which is main
component in the data system. It is a collection of various entities that specific attributes which
define as form of properties. In bike database system, there are different types of entities and
their specific attributes classified in followings ways.
Entity:
Customer
Attributes:
customer_id
customer_namer
customer_title
customer_address

customer_city
customer_postcode
Customer_phone no.
Entity
Invoice table
Attributes
invoice_id
invoice_date
invoice_total
customer_id
item_id
paid_date
Entity
Item
Attributes:
item_id
item_name
order item_date
supplier_no
Entity
Order
Attributes:
Order_id
order_date
order_delivery date
customer_id
Entity
Supplier
Attributes
Supplier_no
Supplier_name

Supplier_address
Supplier_city
Supplier_postcode
Supplier_phone no
Entity
Stock item
Attributes
Stock_id
supplier_no
item serial_no
item_description
wholesale_rate
retail_price
Entity life histories of each of entities
An entity is a real world object whereas it is a collection of similar types of entities. With
specific attributes to share same value in effectively. The main purpose of information system is
provided the accurate and up to date details. The details can be changed according to continuous
change the number and name of customer on the bike shop. Form Example- Price of bicycle
continuously change according to the demand of consumers. In this way, it easily tracks all the
details and information of particular entities (William and et.al., 2012).