Chapter 5, Problem 11CE

Program Plan Intro

Entities and Relationship of “Figure 5-17”:

The entities that are identified in “Figure 5-17” are as follows:

• Drone
• Video
• Facility
• Analysis

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

• “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 much analysis.
    • 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.

List of queries that are created in the “question 5-5”:

The list of queries that utilizes the entities for the given model are given below:

• Provide the list of Videos recorded by each Drone in a specific month.
• Provide the list of videos recorded by a specific facility.
• Provide the list of videos analyzed by a specific Drone.
• Provide the list of videos that is analyzed and recorded by a specific camera type which includes the facility.
• Provide the List of videos that are recorded at an exact facility with the specific altitude defined in the range.
• Provide the list of videos that are analyzed by a particular facility.
• Provide the list of video taken by a particular person (Drone) of a specific facility.