The Sales
Management System (1.0)
For the Maximum Sales
APPORVAL FOR STANDARD FOOD AND BEVARAGES
The Sales
Data Structure and Analysis
Project on
"Sales Management System"
Prepared by: Muhammad Azhar (1642-311009)
MCS (2nd Semester)
Fahad Amin
BCS (2nd Semester)
Submitted to: Professor. Atta
Table of Contents
1. Introduction
1.1 Purpose
1.2 Scope
1.3 Features
2. Description
2.1 System Environment
2.2 Functional requirements Definition
2.3 Project Requirement
2.4 Constraints
2.5 User Specification
3. Flow Charts
4. Data Flow Diagrams (DFD)
5. Entity Relationships Diagram (ERD)
6. Field Tables
7. Wire Frames
8. Screen Shots
1. Introduction
1.1 Purpose
The software is designed to manage the sales operation for one of the esteemed
food and beverages company known as "Standard Food and Beverages". The
company wants to divide the sales location in 4 parts by their distributors which
they will be responsible for the in time sales delivery.
1.2 Scope
The scope of the software to manage all the operations through the distributors. The
distributor will be responsible the run the sales operation through his own sales
team. The distributor will be responsible to produce the maximum assets that are
required by the sales team like, ware house, sales persons, vans, drivers etc…
1.3 Features
Collaboration of the Company and Distributor
Collaboration of the Sales and Distributor
Categorization
Data Sharing
Scheduling
Task Management
Time Tracking
Sales Tasks
Sales Promotions
2. Description
2.1 System Environment
The system is completely desktop application. However the daily sales and
monthly progress will be available on Company's own web site to only
authenticated and privileged users. Cross distributor information is not visible to
the sales team of each distribution. However each distributor can share his sales
targets in monthly progress reports.
A local Lan access is essential to access the software over the network.
User Computer Hub/Switch Computer User
2.2 Functional Requirement Definition
Functional Requirements are those that refer to the functionality of the system, i.e.,
what services it will provide to the user. Nonfunctional (supplementary)
requirements pertain to other information needed to produce the correct system and
are detailed separately
2.3 Project Requirement
Hardware Requirement
Processor RAM Disk Space
======= ==== ========
Pentium IV or Higher 1GB 300 MB
Software Requirements
Operating System Database
============= =======
Win-XP-Win 7-Linux Oracle 10G
2.4 Constraints
The software GUI will be windows based and will support only the English.
Editing will be allowed only to privileged users.
2.5 User Specification
User must me able to basic handling of software.
User should have some basic knowledge of data entry.
English language is mandatory.
3 Flow Chart
4 Data Flow Diagram (Level 0 DFD)
4 Data Flow Diagram (Level 1 DFD)
5 Entity Relationship Diagram (ERD)
6 Field Tables
Distributor Table
Distributor ID Number PK
Distributor Name Text
Distributor Address Text
Distributor Region Text
Area Table
Distributor ID Number FK
Area ID Number PK
Distributor Name Text
Van Table
Distributor ID Number FK
Area ID Number FK
Van ID Number PK
Van Number Var char PK
Driver Name Text
Customer Table
Distributor ID Number FK
Area ID Number FK
Van ID Text Number FK
Customer ID Text Number PK
Customer Name Text
Customer Address Text
Product Table
Product ID Number PK
Product Name Text
Weight Number
Price Number
Bonus NUmber
Sales Table
Distributor ID Number FK
Area ID Number FK
Van ID Number FK
Customer ID Number FK
Product ID Number FK
Product Name Text
Bonus Number
Quantity Number
Price Number
Grand Total Number
Discount Number
Total Amount Number
7 Wire Frame
Add Save Cancel Edit Delete
Distributor ID
Area ID
Van ID
Customer ID
Product ID
Price Quantity Grand Total
Discount Bonus Total Amount
8 Screen Shots
SCREEN SHOTS OF THE SOFTWARE ARE NOT AVAILABLE.
SOFTWARE IS UNDER CONSTRUCTION
