Consider an ONLINE$\_$SHOP database which allows customers to purchase items from the shop on the web. The basic data requirements are summarized as follows:$$ Each customer of the shop is identified by a unique customer number, first and last name, gender, age, address and phone number.$$ Each item sold by the shop is identified by a unique barcode number, itemdescription, unit price, and quantity in stock.$$ Each order placed by a customer is given a unique order number, and contains specified quantities of one or more items to be purchased.$$ Each order also has a delivery address, and records the date of receipt of the payment and an expected shipping date. The actual delivery date is recorded after the customer receives the shopping order.