Grocery Store Database

2639 WordsDec 5, 200511 Pages
Introduction 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
Open Document