Task 1: The EERD contain all necessary entities, relationships, attributes so that all the queries can be answered. Correct entity/relationship types (strong or weak) are used. Each strong entity has a PK Each relationship has the two types of constraints Correct class-subclass relationships are identified There are no redundant entities, relationships or attributes (In particular, […]

I need help with following questions:Design the stored procedure to answer the following question:  What is the utilization of the room for a one week period. The procedure will return a list of the rooms showing how many of each service (procedure or consultation) with the total time used for each plus a grand total […]