[Q.1] Answer the following questions based on the data requirements listed below. [10 points] Data Requirements: Lehman Auto Part factory plans to develop database applications to keep track of the parts sold by employees of the factory to customers. An employee of the factory will get additional bonus if his/her monthly sales amount exceeds $30,000. 1. The factory has employees, each identified by a unique employee Id, first name, last name, two or more email addresses, annual salary, phone number, address. 2. Each customer of the factory is identified by a unique customer Id, first and last name, one email, phone number, and shipping address. 3. Each part sold by the factory is identified by a unique part Id, part name, price, and quantity in stock. 4. Each order placed by the customer is identified by a unique order Id, employee who sold the parts, quantities of one or more parts. Each order has a date-time of the order placed, expected shipping date-time, and actual shipping date-time. (a) Analyze the data requirements and draw a conceptual Lehman AutoFactory database schema in traditional ER diagram. (b) Map the conceptual LehmanAutoFactory" database schema to a logical database schema. The logical database schema must show referential constraints by drawing an arrow that connects a foreign key column of a referencing table to a primary key column of the referenced table. (c) Explain primary key constraints, entity integrity constraints, and referential integrity constraints using the LehmanAutoFactory logical database schema. (d) Let us assume the logical tables are populated, write a SQL statement to retrieve the employee Id and first name, last name, customer Id, customer email address, part Id, and part name, quantity, and actual shipping date-time. (e) Let us assume the logical tables are populated, write a SQL statement to retrieve the employee Id, name, employee's email addresses