Question 3 2 pts A building company HRB builds houses on properties in Australia. Each property has an address, land siz

[answerhappygod]

Question 3 2 Pts A Building Company Hrb Builds Houses On Properties In Australia Each Property Has An Address Land Siz 1 (72.71 KiB) Viewed 44 times

Question 3 2 pts A building company HRB builds houses on properties in Australia. Each property has an address, land size, property owners name, construction start date. (Consider House and Property to have the same meaning). The house will be based on one of HRB building designs. Each design has a code, a design name, total square meters, number of bedrooms, no of bathrooms, and garage size (E.g. Design #M1, Modern, 20 square meters, 3BR, 2 bathrooms, 2 cars). In order to build houses, HRB hire a number of contractors. Each contractor has a name, address and phone number. A number of contractors could work on a house at the same time. For each contractor working on a house HRB records number of working hours. Some contractors work on multiple houses during a year. Each of the contractors has one major qualification, e.g. an electrician, a carpenter, a plumber etc. In fact, there are 15 different skill types that HRB uses. Each qualification has an id, a description and associated payrate (e.g. 3, Plumber, $50). HRB would like to create reports such as: • Which house required the largest number of contractors to work on it. • How many houses of each design has HRB built? . Which major qualification do most contractors have? • How many electricians have been allocated to the house at 1 John St, Hawthorn? Use paper, pencil and eraser to draw the ERD that meets HRB's requirements. Underline attribute and relationship names as appropriate. Make sure all entity names end with 4 digits of your student ID. Put your name and ID above or below the diagram. Make a photo of your answer and upload here.