Answer Happy

Question 1 1 pt The EQT hire club wants to record loans of equipment made by its members. Each member has an id and name. Each equipment item has an id and name. Each time a member makes a loan of a piece equipment, the date must be recorded. Each member has a membership type. A membership type may have many members. The club would like to create reports such as: Which member has made the greatest number of loans?, Which equipment has been loaned the most?, Which membership type has the most members? This ERD has been created so that a database can be built for EQT. Eald Egname Lypsid Description MEMBERSHIP EQUIPMENT TYPE has LOAN MEMBER has Date OfLoan Membid MembName Would a database based on this ERD be suitable for EQT? (Yes or No)? If No, list at least two major problems with this ERD. If Yes, write the relational schema for any two tables based on the ERD. Include all PKs and FKs.
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.