A perfume company called Heaven Fragrant wants to find out about products that customers and employees are in favor of to increase the production line. For that, you are requested to create the tables below:

Table A: Create a table and call EmployeesTable. Select a list of employees with a minimum 10 members consisting of employeeID, FirstName, LastName, HomeAddress, OfficePhone, Department, and FavoriteProducts.

Table B: Create another table and call it CustomersTable. It includes CustomerID, Name, BillingAddress, CreditCard and FavoriteProducts.

1. We want to relate the employees to the Customers Table. What is the best way to do that? Create the above-mentioned tables with the use of SQL Editor and share your code. [10 Marks]
2. Try to reorder the data based on the customer's first names initially then reorder again based on the products that have become most peoples favorite. Share your final tables and SQL code if any.