Please draw out the er to relational diagram for the following: Convert the foll

Question

Please draw out the er to relational diagram for the following:

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

Hi,

Below are the rudimentary schemas that can be drawn from the given E-R diagram-

1. Branch Schema

Branch(rID, rAddress, rPhNum);

2. Agent Schema

Agent(cNum, aName,aPhNum);

3. manages schema

manages(rID, cNum, mSince);

4. WorksAt schema

WorksAt (rID, cNum, wSince);

5. House Schema

House(hID, hAddress, hPrice, hBaths);

6. Lists Schema

Lists(rID,hID, lSince);

7. CanShow Schema

CanShow (hID,cNum, authorizationNum);

8. Room Schema

Room(hID, Type,sqFt);

9. Sale Schema

Sale(hID, sDate, sPrice);

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---