Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

6th International Edition

061921323X, 978-0619213237

More Books

Students also viewed these Databases questions

Question

Differentiate tan(7x+9x-2.5)

Answered: 1 week ago

Question

Explain the sources of recruitment.

Answered: 1 week ago

Question

Differentiate sin(5x+2)

Answered: 1 week ago

Question

Compute the derivative f(x)=1/ax+bx

Answered: 1 week ago

Question

Effective Delivery Effective

Answered: 1 week ago