) HelloHouse Engineering company, is a consultant company that analyzes the construction and condition of houses and oth

[answerhappygod]

) HelloHouse Engineering company, is a consultant company thatanalyzes the construction and condition of houses and otherbuildings and facilities. The company wants to construct a databasefor their work. Engineers who work for the company may have trucks,and each truck must be assigned to an engineer. As a consultant,engineers provide services to the clients. An engineer can providefrom zero to many services, however, a given service must beprovided by an engineer and can be provided by only that engineer.Clients may have services and a service can be requested by manyclients. A client must have purchased at least one service, but aservice does not need to have any clients. Each client can pay adifferent fee for the same service. Sometimes, clients refer to oneanother; a given client can refer to one or more other clients. Aclient may or may not have been referred by another client, but aclient can be referred by only one other client. In addition,engineers earn certificates for their skills. An engineer can earnzero to many types of certifications. Each certification may beearned by zero to many engineers. a) Draw the ER-Entityrelationship diagram. You can use assumptions, if you think thatthe cardinalities are not clearly stated. Write down yourassumptions. b) Resolve Many-to-Many relationships in your diagram,if there are any.