Name of University

 

INTRODUCTION

The database system is designed to store the order, customer, attendant, product, payment and delivery details.

Each time an order is made the system automatically give the order a unique ID, date and the name of product being ordered is entered manually.

Customer details that include his or her name, home address and phone number are also recorded in the system.

The attendant who serves the customer also enters his or her name and the work ID.

Products details such as serial number, price and discount that are to be offered for that particular product are captured in the system.

Payment details and delivery details are also entered in the system .The payment details contain date, mode of payment and receipt number. Delivery details contain delivery date, delivery ID and location.

MISSION STATEMENT

The mission of the system is to provide a cost friendly single widow-platform that will be used to manage and monitor the sales transaction carried out in retail shops, hardwires or even production industries.

 

 

OBJECTIVES

  1. Enhance smooth flow of sales operations.
  2. Minimize the cost of operation.
  3. Ease the management and monitoring of sale activities.
  4. Increase efficiency and accuracy in record keeping.

 

List of entities and their attributes

ENTITY ATTRIBUTES
Order 1.        Order ID

2.        Date

3.        Product  name

 Customer 1.        Customers name

2.        Address

3.        Customer ID

4.        Phone number

Attendant 1.        Work ID

2.        name

Product 1.        serial number

2.        discount allowance

3.        price

Payment 1.        date

2.        mode of payment

3.        receipt number

Delivery 1.        delivery date

2.        location

3.        delivery ID

  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ER DIAGRAM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Order Details

 

Order ID

 

Date

Product

 

 

 

Customer Details

 

Order ID

Customer ID

 

Name

Address

Phone No

 

 

 

 

Attendant  Details

 

Order ID

Work ID

 

Name

 

 

 

Product  Details

 

Order ID

Serial No

Discount

Price

 

 

 

Payment Details

 

Order ID

Receipt No

 

Date

Mode of Payment

 

 

 

 

 

Delivery Details

 

Order ID

Delivery ID

Date

Location