Chapter 5, Problem 5.8CE5

Explanation of Solution

Analysis of the “Figure 5-28”:

The below are the cardinalities that are identified in the “Figure 5-28”:

• “Mandatory one to optional Many” cardinalities.
  • Between Drone and Video entities.
    • A Drone can take many Videos.
    • A video can be taken by one Drone.
    • The instance of the Video is optional for Drone.
    • The instance of the Drone is required for a Video.
  • Between Video and Analysis entities.
    • A Video is the base for many analyses.
    • An Analysis is based on one Video.
    • The instance of the Analysis is optional for Video.
    • The instance of the Video is required for the Analysis.
• “Optional many to Mandatory one” cardinalities.
  • Between Video and Facility entities.
    • Many Video can record a facility.
    • One facility can be recorded by Videos.
    • The instance of Video is optional For Facility.
    • The instance of Facility is required for a Video.

Analysis of the figure created on “Question 5-7”:

The below are the relations that are added in addition into the model of “Question 5-7”:

• The relationship cardinality between the entities “Facility” and “Contact” is “Optional many to Mandatory one”...