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

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

Transform the attached ERD into relation. Use DIA or WORD to answer

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!