We will be using the below scenario of an EasyShop Retail Store as a running example and context for most of the assignments in this course.
Item 1
Pay money
Item 2
Receive item
Receive purchase bill
Item N
Store Manager Security guard
Customers
Purchase transaction
Retail store
Retail store employees
The assignments for the day must be worked out on notepad.
All relations for the retail shop application along with their attributes are mentioned below. A customer can buy multiple items and will receive different bills
for each item bought. A customer can purchase at more than 1 retail outlet. Each retail store will have multiple employees. Employees can work in only 1
retail outlet. Managers are also employees. Customers living at the same address are spouses.
Customer (Custld, CustType, CustName, Emailld, Contact No, Address)
• RetailOutlet (ROID, Location, Managerld)
• Item (Item Code, Item Type, Desc, Price, ReorderLevel, QtyOnHand, Category)
Employee (Empld, EmpName, Designation, Emailld, Contact No, Worksin)
• PurchaseBill (Billld, RetailOutlet, Item, Customer, BillAmount, Bill Date,Quantity)
Answers
Answered by
0
what's this I don't know
noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Similar questions
Geography,
2 months ago
English,
2 months ago
Chemistry,
4 months ago
India Languages,
4 months ago
Math,
10 months ago