Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Metropolitan Housing Corporation (MHC) is a non-profit organization that advocates the development and improvement of low-income housing. The MHC operates in a metro area

The Metropolitan Housing Corporation (MHC) is a non-profit organization that advocates the development and improvement of low-income housing. The MHC operates in a metro area of approximately 2 million people. The MHC maintains information about the location, availability and condition of low-income housing in 11 different census-tracts in the metro area. Within the boundaries of these tracts are approximately 250 different buildings that provide low-income housing. On average, each building contains 25 apartments or other units. The MHC keeps data on each census tract including geographic boundaries, median income, elected officials, principal businesses, principal investors involved in the attributes of that tract, and other demographic and economic data. It also maintains a limited amount of data about crime. For each building, the MHC stores the name, address, size, owners name and address, mortgagor name and address, renovations and repairs, and availability of facilities for handicapped people. In addition, the MHC keeps a list of the units within each building, including the type of unit, size, number of bedrooms, kitchen and dining facilities, location in the building, and any special remarks. The MHC wants to maintain data regarding the average occupancy rate for each unit, but to date has been unable to collect or store such data. The MHC does keep data on whether a unit is currently occupied. The MHC serves as an information clearinghouse and offers three basic services. First, it works with politicians, lobbyists, and advocacy groups to support legislation that encourages the development of lowincome housing through tax incentives, developmental zoning preferences, and other legislative inducements. To accomplish this, the MHC provides information about low-income housing to state, county and city governments. Second, through speeches, seminars, displays at conventions, and other public relation activities, the MHC officials strive to raise the communitys consciousness about the need for low income housing. Finally the MHC provides information about the availability of low-income housing to other agencies that work with lowincome and homeless populations.

Create a DIA Diagram identifying entities, entity type (strong, weak, associative) primary keys, relationships, and cardinalities.

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

Advances In Databases And Information Systems 22nd European Conference Adbis 2018 Budapest Hungary September 2 5 2018 Proceedings Lncs 11019

Authors: Andras Benczur ,Bernhard Thalheim ,Tomas Horvath

1st Edition

3319983970, 978-3319983974

More Books

Students also viewed these Databases questions