Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PRO FOOD Supermarket has had a problem keeping track of their products manually, especially their perishable products. They would like your team of database consultants
PRO FOOD Supermarket has had a problem keeping track of their products manually, especially their perishable products. They would like your team of database consultants to design a database which keeps track of their products they sell. The supermarket stocks various type of products that they categorize as perishables and none perishables. Each item has a name, code, description and a unit price. The perishable items are collected from the suppliers in batches, where each batch has an expiry date. Each batch has the number of original count of product along with the current count of the product. Each perishable item also has unit of measurement for the perishable item. Perishable items store the re-order level of each product along with the quantity currently in the store. When customers are cashing out they are provided with an invoice, that has the products they bought and how much of the product they bought. An invoice number, date and total are also printed on the customer's receipt. The supermarket employees several employees that each have a name, TRN and several telephone numbers that the company wants to track. The employees use a login code which is used to serve customers and is also printed on the receipt handed to the customers. There are certain employees that act as supervisors for the cashier employees. The supermarket believes in non-membership shopping and does not want to store information on customers. Required: 1. Construct an ER diagram from the description above. Include required attributes to make the data storage meaningful. [40
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started