Question: please do the following question 1 part a, b , c thank you I will give you a Like! part a part b part c

please do the following question 1 part a, b , c thank you I will give you a Like!

part a

please do the following question 1 part a, b , c thank

part b

you I will give you a Like! part a part b part

part c

c HAFH Property Management Company building building a bnooffloors bmanagerid manager managerid

HAFH Property Management Company building building a bnooffloors bmanagerid manager managerid mfname miname mbdate msalary mbonus mresbuildingid inspector insid insname Indexes Indexes Indexes managerphone managerid mphone Indeks inspecting insid buildingid datelast datenext Indes corpclient coid ccname ceindustry cclocation ccidreferredby Indexes apartment buildingid aptno anoofbedrooms ced staffmember smemberid smembername Indexes Indes cleaning buildingid *aptno smemberd Indexes What is the cardinality of the relationship from corpclient to apartment? 1:Many A corpclient can be related to multiple apartments. O Many:1 Many corpclients can be related to one apartment. OM:N Many corpclients are related to many apartments The solid relationship line from building to apartment HAFH Property Management Company manager managerid mframe miname mbdate msalary mbonus mresbuildingid building building d bnoofficers bmanagerid inspector insid insname Indes Indexes Indexes managerphone managerid mphone Indexes inspecting insid buildingid datelast datenext Indexes corpclient ceid ccname ceindustry cclocation ccidreferredby Indexes apartment buildingid apto ancotbedrooms cod Indexes staffmember smemberid smembername Indexes cleaning buildingid * aptro smemberd Indexes indicates that... O building is a WEAK entity dependent on apartment apartment is a WEAK entity dependent on building there is a 1:Many relationshp from building to apartment and both are independent entities The solid relationship lines from building to inspecting to inspector indicate... HAFH Property Management Company manager managerid mfname miname mbdate msalary mbonus mresbuildingid building building d bnoofficers bmanagerid inspector insid insname Indes Indexes Indexes managerphone managerid mphone Inder inspecting insid buildingid datelast datenext Indetes corpclient ceid ccname industry cclocation ccidreferredby Intes apartment buildingid aptrio anoofbedrooms cod Indeks staffmember smemberid smembername Indexes deaning buildingid *aptno smemberid Indexes O A 1:M relationship from building to inspector with datelast, datenext as relationship attributes. O An M:N relationshp between building and inspector with datelast and datenext as relationship attributes. Two independent 1:M relationships. From building to inspecting, and from inspector to inspecting

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!