Reference no: EM132757480

Make an Entity-Relationship(E-R) Diagram."

ABC housing society is a medium sized local authority. One of the responsibilities of the Society is the maintenance and repair of Society owned housing within its boundaries. The authority wishes to develop an information system to monitor information on housing repair work, a description of which is as follows:

For the purpose of housing repair work, the society is divided into a number of areas. Each area is subdivided into streets or roads, each street or road in likely to have a number of houses along it. Details of each house are held, along with details of each instance of repair work carried out to a specific house. Each area is maintained by a single repair team, although a team may be responsible for more than one area. A repair team consists of a number of employees, one of whom is designated the team supervisor. The team are allocated a number of vehicles for use in their work, which are generally used by the "owning" team only, although are occasionally "borrowed" by other Teams. Each team is based at a maintenance depot, and in some cases, more than one team may be based at a single depot".