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

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 lines from FKs to PKs.

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.

Explanation / Answer

EMPLOYEE(Employee ID, Employee Name) SALES OFFICE(Office number, Office Location) PROPERTY(Property ID, Property Location,(Address, City, State, ZipCode)) OWNER(Owner ID, Owner Name)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.