Design a database for an online business (e. Amazon) using the below data requirements:

Design a database for an online business (e.g. Amazon) using the below data requirements:

The business has employees identified by a unique employee number, their first and last names, and a city where they are located. The customers of the business are identified by a unique customer number, their first and last names, and a city where they are located.  The items being sold by the business are identified by a unique item number, an item name, their price, and quantity in stock. Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more items. Each order has a date of receipt. The ship date of the order is also recorded.

1)     Design the conceptual schema (using ER Diagrams).                                                 (10)

2)     Design the relational database schema based on the conceptual schema.                 (15)

3)     Design an Oracle/MySQL database using SQL DDL based on the relational schema.                                                                                                                                                             (25)

4)     Populate the database using SQL DML with at least five records in each table and with data appropriate for the below queries.                                                                                (20)

5)     Write SQL queries for the following:                                                                           (30)

a)     Retrieve the full details of all customers.

b)     Retrieve the item info of all items ordered by the customer "Tom Brady".

c)     Retrieve the order numbers processed by the employee "Tony Romo".

d)    Retrieve the names of customers who have ordered at least one item that costs more than $30.00.

e)     Retrieve the names and cities of employees who have taken orders for items costing more than $50.00.

f)      Retrieve the names of customers who order items only from employees who live in the same city as themselves.

g)     Retrieve the names of customers who have orders shipped the same day.

h)    Retrieve the names of customers who have not placed an order.

i)       Retrieve a list of item numbers, item names, and total quantity ordered for each item.

j)       For each employee, retrieve his/her number, name, and total sales (in dollars).