-
Notifications
You must be signed in to change notification settings - Fork 1
/
Final Project Design
115 lines (106 loc) · 2.01 KB
/
Final Project Design
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
Project Task #3 – “Final” Design
By: Shane Folkerts,
Malissa Keller,
Dalton Lee, and
Devin Nemac
Mom and Pop Pet Shop
Customer Entity
The Mom and Pop Pet Shop is our customer. They are a small town family pet store that sells adoptable animals,
food, and accessories. We, Group F, are creating a POS (point of sale) system to be used on their cashier registers.
User Groups
• Administrative :
This is the managerial level.
o Has “God” like access in the system
Create Employee
Delete Employee
Audit Trail
• Transactions
• Inventory worth
• Purchase Orders
Inventory
• Add Product
• Delete Product
• Manually update inventory
o All the options the Employee has well
• Employee
This is the lowest level it can go.
o Has basic access
Log In
Change Password
Item Searching
Shopping Cart
Apply discounts
Receive Inventory
Data Elements
• Employee
o ID (String, restricted to numbers)
o Password (alphanumeric)
o Admin (boolean)
• Item_Price
o ID*
o Cost
o Markup %
o Discount %
• Item_Inventory
o ID*
o Number on Hand
o Minimum on Hand
o Ideal Amount
• Item_Category
o ID*
o Category
o Category Discount
• Item_Name
o ID*
o Name
• Audit_Record
o Audit_Trans_ID*
o Type
Add/Remove Employees
Update Employee Info
Add/Remove Products
Discounts
Stocking
Price Changes
Sales
Transactions
Logins/Offs
Audit Log Accesses
Purchase Orders
o Employee
o Date
Reports
• Transactions
o Total
o Employee
o Date
o Items
o Discounts (if applied)
o Amount paid
• Inventory
o UPC/Sku #
o Name
o Mark-up %
o Number on hand
o Ideal number on hand
o Minimum to keep on hand
o Total worth
o Category
o Cost of item
o Category Discount
o Item added
o Item deleted
• Purchase Order
o Items needed
o Minimum currently on hand
o Cost of each item
o Total cost for entire purchase order
o Email address to send to
• Employee
o When an employee is added
Username
Password
First name
Last name
Admin rights
Email Address