Required:

1. Construct an ER diagram from the description above. Include required attributes to make the data storage meaningful. [40

2. Use your research initiative to determine three other entities (and their attributes) that are of importance to this model.

a. Write a paragraph explaining their importance and relationship with the other entities.

b. In a separate diagram show how they should added to your ER diagram.

3. Based on the final E-R model developed part 2 above define the file structure using relational notation. [20

Scenario: 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