Chapter 5, Problem 5.12CE5

Explanation of Solution

Entities and Relationship of the “Figure 5-28”:

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

• Drone
• Video
• Facility
• Analysis

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 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-6”:

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

• 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.

Processing the queries:

• In the “Create” menu click on the “Query Design” button and “Show Table” dialog box appears.
• Choose the required tables.
• In the “table” option and choose the required table
• In the “field” option and choose the required field.
• Click in the show check button to display the particular field.
• In the criteria provide the required fields that are need to be selected.
• Click on the “Run” button to execute the query.

Query1:

Provide the list of Videos recorded by each Drone in a specific month.

Criteria given:

Between “#6/10/2013#” and “#9/8/2015#”,

Screenshot of creating query

Execution of the query

Query 2:

Provide the list of videos recorded by a specific facility...