A) Transform the ERD diagram to a set of relations and develop a relational schema.

B) Diagram the functional dependencies and determine the normal form for each relation. (Mainly connect all the necessary arrows)

(Transform the attached ERD into relation. Solid underline all PKs, Dash underline all FKs and draw arrowhead lines from FKs to PKs. Use DIA or WORD to answer the question.)

EMPLOYEE Em oyee ID Employee Name Manages Is Assigned SALES OFFICE Office Number Office Location Lists PROPERTY Property ID Property Location (Address, City, State, ZipCode) Owns Percent Owned OWNER Owner ID Owner Name Note: An additional business rule for this scenario is that a EMPLOYEE may Manage only the SALES OFFICE to which she Is Assigned