ASP Mobile Sale System

1
ASP Mobile Sale System

• Analysis Report

2
Group Members

• Ken
• Robin
• Timothy
• Hang

3
Problem Findings

• Management Problems
• Sales Problems
• Warehouse Problems
• Other Problems

4
Problem Findings (2)

• Management Problems
• Difficult to find the sale record
• Not enough sales data for analysing
• Hard to search information

5
Problem Findings (3)

• Sales Problems
• Inconvenient in outdoor selling
• No sales planning
• No discount limit

6
Problem Findings (4)

• Warehouse Problems
• Poor Maintenance in stock level
• Product catalogs organized poorly
• Popular products are not properly recorded

7
Problem Findings (5)

• Other Problems
• Security Problems in database
• Promotion of the new product is not enough
• Data type error

8
System Requirement

• PC functions
• Manager functions
• Sales functions
• Warehouse functions
• Maintenance functions
• Other functions
• PDA functions
• Conduit functions

9
System Requirement (2)

• Manager functions
• Function for the manager to set the discount
  limits
• Function for the manager to assign the
  salesperson to sales visit
• Function for producing sales records.
• Function for the manager to define the
  promotion items on individual product.

10
System Requirement (3)

• Sales functions
• Function for entering and scheduling the plan for
  sales visits
• Function for supporting and recording the orders
  from the Internet
• Function for producing confirmation of orders
  before processing each order.
• Function for making ordering status available in
  the Internet

11
System Requirement (4)

• Warehouse functions
• Function for processing products receiving , bad
  products returning and products delivering.
• Function to acknowledge orders.
• Function for monitoring the stock level of the
  product
• Function for producing reorder list.

12
System Requirement (5)

• Maintenance functions
• Function for adding, editing and deleting
  information from the system.
• Function for adding and editing the reorder level
  by responsible officer.
• Function for allowing the salespersons to give
  discounts to the customers within a limited
  percentage

13
System Requirement (6)

• Other functions
• Function for the salespersons to view their sales
  records
• Function for producing a products list
• Company website will be created

14
System Requirement (7)

• PDA Functions
• Function for retrieving information from the PDA
  device.
• Function for entering the sales order in the PDA
  device

15
System Requirement (8)

• Conduit functions
• Function for downloading the selective
  information to the PDA devices
• Function for uploading the orders to the PC

16
Data Flow Diagram

• Context Diagram of The System
• Level 0 DFD of The System
• Level 1 DFD of The Process
• Login
• Placing Order
• Internet service
• Using PDA
• Handling Warehouse
• File Maintenance

17
Context Diagram of The System
C Customer
Information request
S Sales
Reject notice
Customer Orders
Personal details
Password (login)
Competitor information
Order
Customer ID / password
Request info.
Confirmation of orders
Promotion schedule
Product info. via email
O Officer
Password (login)
Mobile Sales System for ASP Company
Change product info.
Acknowledge orders
Product catalogs
Password (login)
Stock level detail
Product quality
Info. request
Discount
Request info.
Sales order
WO Warehouse Officer
Promotion plan
Delivery notes
M Manager
Password (login)
New product info.
Acceptance / Back order notes
Reorder list
PD Purchasing Department
18
Level 0 DFD of The System
Customer orders
C Customer
S Sales
Password (login)
Confirmation of orders
2 Placing Order
Info. request
Order
Competitor info.
3 Internet Service
Personal details
4 Using PDA
Request info.
Request info.
Customer ID / password
Login success
Promotion schedule
1 Login
Password (login)
Acknowledge orders
7 Data Maintenance
O Officer
New product catalogs
Password (login)
Sales order
Changed product info.
WO Warehouse Officer
6 Handling warehouse
5 Manage Activities
Product quality
Promotion plan
Discount
Stock level detail
PD Purchasing Department
M Manager
Acceptance / back order notes
Request info.
Reorder list
Info. request
New product info.
Password (login)
19
Level 1 DFD of The Process 1. Login
Customer ID / Password
Customer detail
C Customer
Customer detail
New Customer
Customer detail
Customer ID / Password
Customer ID / Password
S Sales
Login success
Password (login)
Go to 3. Internet Service
O Officer
Login success
Password (login)
Go to other function 4,5,6,7
Username / Password
M Manager
Password (login)
Employees info.
WO Warehouse Officer
Password (login)
20
Level 1 DFD of Process 2. Placing order
C Customer
Reject notice
Confirmation of order
Order from phone / fax
Accepted order
Rejected order
D3.
Customer Order record
Accepted order
Order
Order from Internet
Customer order
From 3. Internet Service
Ordered items list
Item details
From 6.1 Make acknowledge
Sale order
From S. Sales
Go to WO. Warehouse Officer
21
Level 1 DFD of Process 3. Internet service
Product information via email
C Customer
Information request
Request information
Information request
Product information
Order
Information request
Order status
Product information
Login success
Order
Go to 2. Placing order
Order status
From 1. login
22
Level 1 DFD of process 4. Using PDA
Promotion schedule
S Sales
Information request
Request info.
Customer information
Customer order
Product information
Competitor information
Promotion schedule
Customer order
Competitor information
Customer Order
Go to 2. Placing order
23
Level 1 DFD of Process 5. Manage activities
Calendar ( System provide)
M Manager
Promotion schedule
Promotion plan
Discount
Sales information
Sales discount
Product discount
24
Level 1 DFD of Process 6. Handling Warehouse
From 2.5 Prepare sales order
From Supplier
Sales order
Product
Receive success
Go to 2.5 Prepare sales order
WO Warehouse Officer
Acknowledge orders
Stock level detail
Sales order
Delivery notes
Reorder list
Go to PD Purchasing department
Received product
Acceptance notes
Qualify product list
Back order notes
Unqualified product list
25
Level 1 DFD of Process 7. File maintenance
Product Information
Change product info
O Officer
New product catalogs
Info. request
S Sales
Information
Own sales record
Edit data
Sales record
Info. request
M Manager
Edit data (New product info.)
Report
Information
Info. request
26
Entity Relationship Diagram (ERD)

• There have 9 Entities.
• Employee Salesperson
• Customer Order
• SalesPromotion OrderLine
• Product Competitor Product
• Competitor

27
The Key Attributes In Each Entity

• Entity Primary key
• Employee --------------- EmployeeNo
• Customer -------------- CustomerNo
• SalesPerson ----------- SalesPersonNo
• Competitor ------------- CompetitorNo
• Order -------------------- OrderNo
• Product ----------------- ProductNo

28
The Key Attributes In Each Entity

• Entity Primary key
• SalesPromotion ----------- OrderNo
• 
  SalesPersonNo
• OrderLine ------------------- OrderNo
  ProduceNo
• CompetitorProduct ------- CompetitorNo
  ProduceNo

29
The Overview of ERD
30
The relation between Employee SalesPromotion
Employee

• Each salesperson has anywhere from zero to many
  sales promotion reports
• Each sales promotion reports only for one
  salesperson

Sales person inherits attributes from Employee
d
SalesPerson
SalesPromotion
31
The relation between Customer Order
Customer

• Each customer can have anywhere from zero to many
  orders
• Each order is just placed by one customer

Order
32
The relation between Salesperson Customer
Customer
SalesPerson

• Each customer is served by one salesperson.
• Each salesperson is responsible for many
  customers.

33
The relation between Order SalesPromotion
Order

• A sales promotion report has one or more than one
  order
• Each order just for one sales promotion report

SalesPromotion
34
The relation between Product Order
OrderLine
Order
Product

• The relation between Order and OrderLine
• A order has one or more than one order line
• A order line is only for one order.
• The relation between OrderLine and Product
• A order line require one or more than one
  products
• A product is only for one order line.

35
QUESTION TIME
36

• End