2. Consider the following relation with five attributes: PLACEMENT(AgentID, TeamID, Role, Office, Country) The functiona

[answerhappygod]

2 Consider The Following Relation With Five Attributes Placement Agentid Teamid Role Office Country The Functiona 1 (59.35 KiB) Viewed 29 times

2. Consider the following relation with five attributes: PLACEMENT(AgentID, TeamID, Role, Office, Country) The functional dependencies in PLACEMENT are: TeamID, Role → AgentID AgentID → TeamID, Role TeamID → Office Office → Country PLACEMENT has two candidate keys: {TeamID, Role) and (AgentID}. PLACEMENT is not in BCNF. Construct a decomposition of PLACEMENT into a collection of BCNF relations that has the lossless join property. Use the algorithm given in class, and show your work. (That is, at each step, state which functional dependency you are removing from which relation in the decomposition, and what the resulting decomposition is after you remove it. Answers that show only the final result without explaining the steps taken to obtain it will receive little or no credit.) Remember that when you remove a functional dependency XY from a relation R, you must remove all attributes in (X- X) from R.