Point of Sale Analysis

Only available on StudyMode
  • Download(s) : 185
  • Published : January 15, 2013
Open Document
Text Preview
Friends Shopping Mart POS
Company Friends shopping mart is best shopping mart to sale each and every type of product to its customers. There are number of employees are working in this shopping mart. Each employee has unique Employee id. Employee data is maintaining by: * Employee_id

* Employee_First_Name
* Employee_Last_Name
* Employee_Cell
* Employee_Street
* Employee_City
* Employee_Country
* Employee_Designation_id
Here Employee_Designation_id is foreign key from designation Table. Designations are defined for herachirary of employee’s. Like Manager, Sales Boy, Account officer cashier etc. Designation table is maintain like: * Designation_id

* Designation_Name
Shopping mart has number of vendors to buy different selling items. Vendor’s data is maintaining by: * Vendor_id,
* Vendor_Address
* Vendor_Phone1
* Vendor_Phone2
* Vendor_Street
* Vendor_City
* Vendor_Country
* Category_id
Here Category_id is foreign key from category table to categorized vendors according to products. All Items’ categories are defined in store Electronics, Plastics, and Wood etc. Category Data is maintain by: * Category_Id,

* Category_Name.
Each item is then categorized and given unique id. Items data is maintain by: * Item_id
* Item_Name
* Item_Sale_Price
* Item_Purchase_Price
* Item_Quantity_on_Hand
* Item_Quantity_Slaeout
* Category_id,Vendor_id
Category_id & vendor_id is used here as foreign Key from category and vendor. On sale time each sale item’s history is maintain through its unique sale_id. Sales data is mainting like: * Sale_id,Date

* Customer_id
For sales detail how many items has been sold to customer sales table is defined like * sale_detail_id
* sale_id
* Item_id
* Item_sale_Price
* Quantity_to_Sale
* Tax
* discount
* Total
Here sale_id is foreign Key from sale table.
We have to save customer data...
tracking img