Point of Sale Analysis

Topics: Sales, Data modeling, Consultative selling Pages: 3 (324 words) Published: January 15, 2013
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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Point of Sale Essay
  • Point of Sale Essay
  • Point of Sale Essay
  • Essay about point of sales
  • Point of Sales Essay
  • Essay about Point of sale
  • Essay about Point of Sales

Become a StudyMode Member

Sign Up - It's Free