Grocery Store Database - 2639 Words

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 Marts 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 companys 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  · AShow MoreRelatedElectronic Product Code ( Upc )1044 Words   |  5 Pageseverything that customers buy from shopping centers has a Universal Product Code (UPC) printed on it. RFID tags are improved version of the UPC bar code as they have read and write capabilities, indicating that they could be read by RFID scanners and also store information. Each product within the shopping center will be labeled with a unique Electronic Product Code (EPC) that will take the place of UPC bar code. Each label could contain 96 bits of information, including names of products, the manufacturersRead MoreCustomer Retention1590 Words   |  7 Pagesand Canadian firms today are experimenting with database marketing programs aimed, in large part, at retention. Most of these companies are not yet sure whether their experiments will be successful. A significant number of the programs will fail and ultimately be scrapped. How do such programs work? Let’s look at the theory. I like to go back to the old corner grocer. Prior to 1950, most groceries in the US and Canada were sold in small grocery stores. The proprietor would meet you at the door. HeRead MoreKudler Fine Foods Design1022 Words   |  5 Pagesthe web community as a whole, and layout of the site. Review of Current Site The current site has some basic information that a client or prespective client would want to know; the store hours, location of the stores, departments within the store, and varity of the items and goods located in the stores. The site uses few graphics and plain text, each page and sub pages are all uniformly the same and built in HTML. There is no CSS detected so each individual page will have to have its ownRead More Biometric Payment Essays916 Words   |  4 Pagesfingerprint coming to a store near you. Buying groceries with a touch of a finger is already being marketed and used in many stores. Finger scanning will soon be ubiquitous, offering speed and convenience to consumers. It will help protect and prevent identity theft. Kids growing up now cannot imagine you needing a cord to use a telephone. Soon they will be saying, â€Å"You mean you had to carry around a piece of plastic or a piece of paper to buy something?† Right now about 500 stores are offering biometricRead MoreAnalyzing Amazon s Market Situation1611 Words   |  7 PagesSituational Analysis – Strengths By analyzing Amazon’s market situation, there are several strengths that encourage the opening of a drive-thru grocery store in Toronto. The built in feature of a drive-thru will offer a less time-consuming way for customers to shop for groceries, providing more convenience. In a contemporary society, especially in Toronto, people have a very busy lifestyle due to today’s stressful work lifestyle. From research completed in 1999, more than 25 million Americans, almostRead MoreGlobal Strategy Case Study1551 Words   |  7 Pagesis fierce in the grocery industry, and one way to sustain a competitive advantage is to have a global strategy. Since opening in the 1900’s, Aldi has opened stores in over 18 countries and continues to grow their multinational enterprise (Aldi, 2017). There are several reasons why Aldi chooses to have a global presence which includes accessing larger markets and achieving economies of scale. To adapt to the culture in different countries, they vary the products sold in each store. Most importantlyRead MoreLow Income Residents : The United States Department Of Agriculture1420 Words   |  6 Pagesresidents of the affected area. Previous research helped develop methods that were used in this study. Studies include the New York City Department of Planning’s â€Å"Going to the Market†: New York City’s grocery store and supermarket storage†, Junfeng Jiao’s dissertation, â€Å"Built environments, grocery shopping, travel behavior and food deserts. Also, Brian Ho-Yin Lee’s dissertation about â€Å"Accessibility and Location choice: Innovations in Measurement and Modeling† was used as well as the USDA’s reportRead MoreSwot Analysis Of Home Chef1608 Words   |  7 Pagesshort period. Consequently, faster business performance would be able for the company, which can also the improve business agility. Furthermore, the company is now capable to perform data analysis across multiple data sources including its corporate database, website, distribution centers, customer care tickets and application usage. This new technology of HelloFresh provides more business op portunities to expand their market shares. 2) Amazon A competitive fighter has entered the meal kit octagonRead MoreTesco vs. Webvan: Grocery Companies Leveraging the Internet1178 Words   |  5 Pages1.0 Introduction The grocery industry is a huge, fragmented and enormously competitive environment and there are currently several examples of grocery companies that are making effective use of the internet as a link with customers (Delaney-Klinger, 2003). In particular, Tesco currently have internet channels for selling groceries that are profitable (Hall, 2001; Koller, 2001). During the late 1990’s many new companies were set up to utilise the perceived advantages from using the internetRead MoreWhat Should I Have For Dinner?758 Words   |  4 Pages a photo of the contents of a pantry will become a database of currently available food. Similarly, users input recipes in the same manner. The user is also able to add what is called a Food Profile to their own contact information. The information [] in this profile includes food preferences, food allergies, and diet objectives. []. Intelligently collected data does not require active user input. EAT pulls data from selected grocery stores including sales and coupons. Further, EAT mines for