Using the Classic Models database (for the UML model) and Classic Models relation scheme (for the relation scheme model) write the relational algebra statement for the following queries: 1. List all Customers that are located in the same state as an Office

2. List all Customers who have ordered Products where the vendor is Classic Metal Creations

3. List all Customers whose Order was shipped within three days of being ordered

4. List all Customers, their service reps and the Offices that the service reps work in

5. List the Employee and their Customers even if the Employee is not working with a Customer

6. List the Employee first and last names and Customer contacts first and last names

7. List all Orders where the quantity of a product orders is greater than the quantity of that product on hand

8. List the Employee LastName and FirstName that work in Japan

The MySQL sample database schema consists of the following tables Customers: stores customer's data Products: stores a list of scale model cars. ProductLines: stores a list of product line categories Orders: stores sales orders placed by customers. OrderDetails: stores sales order line items for each sales order. Payments: stores payments made by customers based on their accounts Employees: stores all employee information as well as the organization structure such as who reports to whom. Offices: stores sales office data OrderDetails quantityOrdered priceEach orderLineNumber Products productCode productName ProductLines productLine textDescription htmlDescription image Showcase> productScale productVendor productDescription quantitylnStock buyPrice MSRP contains Orders rderDate requiredDate shippedDate Employees -is supervised by> lastName firstName extension email reportsTo:Employee jobTitle 0..1 Customers Place 1.status omments customerName contactLastName contactFirstName phone addressLine1 addressLine2 -supervises> Service> 1..1 Payments checkNumber paymentDate 0..1 Remit> Offices 1amount ty phone addressLine1 addressLine2 state state postalCode ountry creditLimit 1..1 house ountry postalCode territory 1..1