ONLY ER DIAGRAM WITH CROW FOOT NOTATION IS REQUIRED.

You have been hired to design a database system for an online store. The database must encompass the customers, items, item categories and the orders made. You have the following information about the way the store operates: Customer details must be recorded. This includes a customer number, first name, last name, email address and password. The store wishes to implement a referral system to reward customers who tell others about the store. Therefore, customer details should also include a referrer column, which will contain the customer number of the customer who referred them, if applicable (not all customers are referred by someone). The store wishes to ensure that each customer has a different email address. This wont influence your E-R model, but will be relevant in Assignment 2. Item details must be recorded. This includes an item number, name, description and price. A list of item categories must be recorded, and the database must keep track of which items are in which categories. All items are in at least one category, but can be in several of them. The only category details required are a category ID number and category name. Obviously, a category can have many items in it. Details of orders made by customers must be recorded. This includes an invoice number, the date/time of the order, a delivery address and a billing address, as well as the customer number of the customer who made the order. For each order, the database must also record details of ordered items and the quantity ordered. Each order must contain at least one item, and an item can be in multiple orders. Based on the details above, you are required to draw both a logical E-R diagram for this database and then a corresponding physical E-R diagram. Clearly show all cardinality, primary and foreign keys, attributes and relationships as appropriate.