a. Study Figure 5-28 to understand the entities and their relationships. Justify each of the cardinalities in this model. (Figure below)

b. Develop a list of seven queries that together use all of the entities in Figure 5-28.

c. Modify the E-R model in Figure 5-28 to include a Contact entity that is related to the Facility entity. Create the relationship, and specify and justify the relationships cardinalities.

d. Discuss the advantages and disadvantages of the model you created in your answer to question c and the model in Figure 5-28.

e. Transform the data model in Figure 5-28 into a relational database design.

f. Create an Access database for your design in question a-e.

Drone Video Facility DronelD Type CameraType AcquisitionDate TopSpeed Ceiling VideolD Date StartTime Length Altitude URL FacilitylD Address Type ContractID ContactName ContactPhone Analysis ID Date Time Employee Comments