Question
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
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