Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
part b
part c
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 inspectingStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started