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.

Question

Want to see the full answer?

Answer 1

Question

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.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Exercise docID document text docID document text 1 hot chocolate cocoa beans 7 sweet sugar 2345 9 cocoa ghana africa 8 sugar cane brazil beans harvest ghana 9 sweet sugar beet cocoa butter butter truffles sweet chocolate 10 sweet cake icing 11 cake black forest Clustering by k-means, with preprocessing tokenization, term weighting TFIDF. Manhattan Distance. Number of cluster is 2. Centroid docID 2 and docID 9.

Change the following code so that there is always at least one way to get from the left corner to the top right, but the labyrinth is still randomized. The player starts at the bottom left corner of the labyrinth. He has to get to the top right corner of the labyrinth as fast he can, avoiding a meeting with the evil dragon. Take care that the player and the dragon cannot start off on walls. Also the dragon starts off from a randomly chosen position public class Labyrinth { private final int size; private final Cell[][] grid; public Labyrinth(int size) { this.size = size; this.grid = new Cell[size][size]; generateLabyrinth(); } private void generateLabyrinth() { Random rand = new Random(); for (int i = 0; i < size; i++) { for (int j = 0; j < size; j++) { // Randomly create walls and paths grid[i][j] = new Cell(rand.nextBoolean()); } } // Ensure start and end are…

Change the following code so that it checks the following 3 conditions: 1. there is no space between each cells (imgs) 2. even if it is resized, the components wouldn't disappear 3. The GameGUI JPanel takes all the JFrame space, so that there shouldn't be extra space appearing in the frame other than the game. Main(): Labyrinth labyrinth = new Labyrinth(10); Player player = new Player(9, 0); Dragon dragon = new Dragon(9, 9); JFrame frame = new JFrame("Labyrinth Game"); GameGUI gui = new GameGUI(labyrinth, player, dragon); frame.add(gui); frame.setSize(600, 600); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.setVisible(true); public class GameGUI extends JPanel { private final Labyrinth labyrinth; private final Player player; private final Dragon dragon; //labyrinth, player, dragon are just public classes private final ImageIcon playerIcon = new ImageIcon("data/images/player.png");…