Using MIS (10th Edition)
Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
bartleby

Concept explainers

Expert Solution & Answer
Book Icon
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...

Blurred answer
Students have asked these similar questions
What are the major threats of using the internet? How do you use it? How do children use it? How canwe secure it? Provide four references with your answer. Two of the refernces can be from an article and the other two from websites.
Assume that a string of name & surname is saved in S. The alphabetical characters in S can be in lowercase and/or uppercase letters. Name and surname are assumed to be separated by a space character and the string ends with a full stop "." character. Write an assembly language program that will copy the name to NAME in lowercase and the surname to SNAME in uppercase letters. Assume that name and/or surname cannot exceed 20 characters. The program should be general and work with every possible string with name & surname. However, you can consider the data segment definition given below in your program. .DATA S DB 'Mahmoud Obaid." NAME DB 20 DUP(?) SNAME DB 20 DUP(?) Hint: Uppercase characters are ordered between 'A' (41H) and 'Z' (5AH) and lowercase characters are ordered between 'a' (61H) and 'z' (7AH) in the in the ASCII Code table. For lowercase letters, bit 5 (d5) of the ASCII code is 1 where for uppercase letters it is 0. For example, Letter 'h' Binary ASCII 01101000 68H 'H'…
What did you find most interesting or surprising about the scientist Lavoiser?
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning