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

[answerhappygod]

3 Hellohouse Engineering Company Is A Consultant Company That Analyzes The Construction And Condition Of Houses And Ot 1 (81.04 KiB) Viewed 22 times

3) HelloHouse Engineering company, is a consultant company that analyzes the construction and condition of houses and other buildings and facilities. The company wants to construct a database for 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 provide from zero to many services, however, a given service must be provided by an engineer and can be provided by only that engineer. Clients may have services and a service can be requested by many clients. A client must have purchased at least one service, but a service does not need to have any clients. Each client can pay a different fee for the same service. Sometimes, clients refer to one another; a given client can refer to one or more other clients. A client may or may not have been referred by another client, but a client can be referred by only one other client. In addition, engineers earn certificates for their skills. An engineer can earn zero to many types of certifications. Each certification may be earned by zero to many engineers. a) Draw the ER-Entity relationship diagram. You can use assumptions, if you think that the cardinalities are not clearly stated. Write down your assumptions. b) Resolve Many-to-Many relationships in your diagram, if there are any.