Create an ERD from the case study:

The Case Study Peters Perpetual Petrol (PPP) is a small chain of petrol stations. Peter, from PPP, wants you to specify the data storage requirements for the PPP information system: 1. PPP sells a number of products, all of which have a unique product name and price.

2. A sale of fuel needs to record the fuel code, e.g., U91 stands for Unleaded 91 and DL stands for Diesel.

3. All of our prices change, including the fuel we need to record the sales price.

4. We sell hot food. Hot food has a standard wait time, e.g., if the customer orders a hot dog, the clerk should tell them it will take three minutes.

5. We sell other products too, like milk.

6. We need to keep track of how many products are sold in each purchase.

7. Oh, I also keep track of the date and receipt number for each purchase too.

8. We do have some regular customers, but we do not track them much. We just ask them what their postcode is.

9. Each station has at least one manager.

10. A manager can manage multiple stations.

11. We need the managers contact details so we can discuss things with them when they are at work at a station. We need the managers employee Id, name (title, first name, and lastname), their work address (number, street, city, postcode), their email address, mobile number and their work phone number.

12. Most managers have a supervisor who is also a manager.

13. To help with training, some of the newer managers have a buddy manager who is paid a set number of hours each week to mentor them. Training, Purchasing Patterns, Profitable Price Ranges, Clerks, Payments, and Publicity Campaigns are outside the scope for this case study