Grocery Store Database

2639 Words11 Pages
Florida Food Mart is a medium size grocery store located in Tampa, Florida. The store and management offices are housed in a 20,000 square foot facility on the North West side of Tampa. There are approximately 45 employees consisting of 20 Cashiers, 10 Stock Clerks, 8 Bagging Associates, 3 Shipping and Receiving Clerks, 3 Store Managers, 1 Technician, 2 Purchasing Agents, 1 Accountant, 1 Marketing Director, 1 Vice President, and 1 President. The Database Team has been assigned the task of upgrading Florida Food Mart's outdated inventory processing system by designing and implementing a state of the art relational database management system utilizing MS Access integrated with Florida Food Marts present point-of-sale (POS)
…show more content…
This system will facilitate increases in productivity that will result in a substantial improvement to the company's bottom line.
Business Rules
The Database Team has established some business rules as it pertains to the grocery inventory system. The following list is a comprehensive list of the rules:
· An employee can only be attached to one department
· A purchase order (PO) must be authorized by a designated employee
· A vendor can have an account, even though they may not have supplied the company in some time
· PO may only have one shipping method
· A PO can only have one invoice or shipping/receiving ticket
· A

More about Grocery Store Database

Get Access