Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

part b

image text in transcribed

part c

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases And Python Programming MySQL MongoDB OOP And Tkinter

Authors: R. PANNEERSELVAM

1st Edition

9357011331, 978-9357011334

More Books

Students also viewed these Databases questions