MUST BE CONNECTED WITH LINES Convert the following ER diagram into a rudimentary

Question

MUST BE CONNECTED WITH LINES

Convert the following ER diagram into a rudimentary relational schema[1]. The diagram describes part of the business of a real state company that has several branches. The diagram should be self-explanatory. One comment is probably needed about the week entity “Room”. Here, the rooms in a house are named uniquely within any given house – for example: bedroom-1, bedroom-2, den, family room, study, etc.

[1] R1 (A, B, C, D)   R2(X, Y, A)

Underline the primary keys of the relations. For the foreign keys use italics or draw the arrows from the F.K. to the P.K.

realtors-2 dia rAddress Branch rPhNum 1Since Lists ID hAddress House hPrice nBaths. type SqIt Room mSince Manages Works At wsince SDALc Sale aNamc aPhNum Agent authorizationNum M Can Show

Explanation / Answer

Here in this er diagram already primary keys are mentioned with underline. And there is no need to change or add anything for this er diagram.

When we convert this er diagram to relational model all the foreign keys to the respective entities will be added.

For an instance now just follow the below steps inorder to understand the how the foreign keys are get added.

Other than that if we want to see this as erdiagram only the existing is enough.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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