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

Customer, Date OrderID

Employee Manager

OrderID, Date Customer, Employee

Date Manager

1) Is the decomposition of the relation schema ORDER into ORDER1=fCustomer, Dateg and ORDER2=fCustomer, OrderID, Employee, Managerg 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 a lossless and dependency-preserving 3NF decomposition for the above relation schema ORDER. You need to include the main steps used for identifying the 3NF decomposition.