Consider the relation schema ORDER={Customer, Date, OrderID, Employee, Manager}and the following set of FDs:

Customer, DateOrderID

EmployeeManager

OrderID, DateCustomer, Employee

DateManager

1 Is the decomposition of the relation schema ORDER into ORDER1={Customer, Date} and ORDER2={Customer, OrderID, Employee, Manager}lossless? Justify your answer.

2 Identify a lossless BCNF decomposition for the above relation schema ORDER. You need to include the main steps used for identifying the BCNF decomposition. Check if this BCNF decomposition is dependency-preserving and justify your answer.

3 Identify alossless and dependency-preserving 3NF decomposition for the above relation schema ORDER. You need to include the main steps used for identifying the 3NF decomposition.