Question

OfficeNo EmployeelD Location assigned SALES OFFICE Name EMPLOYEE isListedWith OwnerlD Pid PROPERTY OWNER Name Owns PercentageOwned) Location Zip Address City State

Convert the E-R diagram above into relations statements. You may present the relations in either the graphical representation or the textual notation. See Relational Properties>Understanding the Correspondence between ER Diagrams and Relations>Relation Statement Notation for examples of both styles.

Answer 1

office No Employ D Loation Name 5ales office. H Bssiyned Repieent Singevalue An eee Salesoffie ul be assigned to multiple empleyees Employee Respresenk Multple Values Byt Employee wtI be assigned to 9Ingle Saleg offire an a Owner Piopen ty Owned Repsesenb MulbValues Gerientage mutHivalus Repiegen h Above vela ton Saysthat Pooperty uull hawe multiple owney and a multple Psopesties. Single Here Rela hon"owned" also contains will own a Owner a tribute (estentage) one

LOcation effice No Tt Means Salesoffice may hawe multple psofortieg Cnot mandadoy) but Sales office Poopenty uillbe linred uith only caleg office ResPesent Smglevake one Listed wit ophional (wot mandatos) Multiple valuer Pcpenty PID lo ca tion State Addbers Cil

SalesOffice Table

Attributes (OfficeNo,Location)

Employee Table

Attributes (EmployeeID,Name)

Assign Table

Attributes (officeNo,EmployeeID)

Property Table

Attributes (PID,Address,city,state,Zip)

Owner Table

Attributes (OwnerID,Name)

Owned Table

Attributes (PID,OWNERID,Percentage)

OfficePropertyMapping Table

Attributes (OfficeNO,PID)

If you left with any doubt, feel free to ask.