How to construct an idef1x entity-relationships diagram

Assignment Help Computer Engineering
Reference no: EM1335919

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 midwestern city. The MHA maintains data about the location, availability, and condition of 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 geographic boundaries, median income of the 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)?s name and address, mortgagor(s)?s name and address, renovations and repairs, and avail-ability 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 wants 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 whether a given unit is occupied.
The MHA serves as an information clearinghouse and offers three basic ser-vices. First, it works with politicians, lobbyists, 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 community?s 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 the low-income and homeless populations.

A. Make a list of possible entities for a database to support MHA?s information needs.
B. Construct an IDEF1X entity-relationships diagram for the entities in question A.
C. Name each relationship and ensure that you have correctly defined the minimum and maximum cardinalities.

Reference no: EM1335919

Questions Cloud

Construct and make a list of potential entities : The Jefferson Dance Club teaches social dancing and offers both private and group lessons. Jefferson charges $45 per hour per student (or couple) for a private lesson and charges $6 per hour per student for a group lesson.
Investigating a case : The United States Supreme Court recently held that if police fail to knock and announce then whatever evidence they seize will not be subject to the exclusionary rule.
Explain about strategic hrm : Strategic HRM - About Vermont Industries Wrought Iron (from their main web-site): Vermont Industries Wrought Iron
When a company''s culture is out of sync : When a company's culture is out of sync with the values, practices, and behavioral norms needed for good strategy execution, which?
How to construct an idef1x entity-relationships diagram : The Metropolitan Housing Agency (MHA) is a non-profit organization that advocates development and improvement of low-income housing. The MHA operates in a metropolitan area of approximately 2.2 million people in a midwestern city.
Find the best method to conduct training : Find the best method to conduct each of the three training stages above and Is a certification exam required
Calculating pv ev and ac : With the Cost one calculates PV EV and AC.
Media specialist company''s strategic plan : Explain how the human resources assistance plan and aids you have been working on for your final project fit into the Media Specialist company's strategic plan.
Deal with high velocity change : In trying to deal with high-velocity change, a company's three strategic postures or options are which?

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd