Question: Please, Develop an E-R Diagram for this project. Thanks!! Develop an E-R Diagram for a database to support the tracking needs of the following organization:
Please, Develop an E-R Diagram for this project. Thanks!!
Develop an E-R Diagram for a database to support the tracking needs of the following organization: The Metropolitan Housing Agency (MHA) is a non-profit organization that advocates the development and improvement of low-income housing. The MHA operates in a Metropolitan area of approximately 2.2 million people in a mid-western city.
The MHA maintains data about the location, availability, and condition or low-income housing in 11 different census tracts in the metropolitan 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 MHA keeps data about each census tract, including geographical boundaries, median income of population, elected officials, principal businesses, principal investors involved in attributes in that tract and other demographic and economic data. It also maintains a limited amount of data about crime. For each building, the MHA stores the name, address, size, owner(s) name and address, mortgagor(s) name and address, renovations and repairs, and availability of facilities for handicapped people. In Addition, the MHA keeps a list of each of the units within each building, including the type of unit, size, number of bedrooms, number of baths, kitchen and dining facilities, location in the building, and any special remarks. The MHA would like to maintain data regarding the average occupancy rates for each unit, but to date, it has been unable to collect or store such data. The MHA does, however, keep data about occupants and availability of a given unit.
The MHA serves as an information clearinghouse and offers three basic services. First, it works with the politicians, lobbyist, and advocacy groups to support legislation that encourages the development of low-income housing through tax incentives, developmental zoning preferences, and other legislative inducements. To accomplish this, the MHA provides information about low-income housing to state, county, and city governments. Second, through speeches, seminars, displays at conventions and other public relations activities, the MHA officials strive to raise the communitys consciousness about the need for low-income housing. Finally, the MHA provides information about the availability of low-income housing to other agencies that work with low-income and homeless populations.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
