Which of the following options most correctly expresses the equation to generate a new variable: "TicketSales" to compute the overall ticket sales, using data from the Tour Type table? (as you would type in the expression builder) O TicketSales: [Trip] * [TourType] TicketSales: [Trie][NumPeople! (pollTicketBricol

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Helicopter
HelicopterID
HelicopterName
HelicopterModel
SeatingCap
Hourly Cost
DateLastMaint
1(1, 1)
Takes
M/(0, N)
Trip
TripID
HelicopterID
PilotID
Tour TypeID
TripDate
StartTime
NumPeople
M
(0, N)
M
(0, N)
Belongs
to
Controls
Tour Type
Tour TypeID
Tour TypeName
ExpectedHours
TicketPrice
(1, 1)
1
(1,1)
Pilot
PilotID
SSN
FirstName
LastName
Street
City
State
ZipCode
Phone
Date of Birth
Which of the following options most correctly expresses the equation to generate a new variable: "TicketSales" to compute the overall ticket sales, using data from the Trip table and the
TourType table? (as you would type in the expression builder)
O TicketSales: [Trip] * [TourType]
O TicketSales: [Trip]![NumPeople] * [TourType]![TicketPrice]
TicketSales= [Trip]! [NumPeople] * [TourType]![TicketPrice]
O TicketSales: [TourType]! [NumPeople] * [Trip]![TicketPrice]
TicketSales: [Num People] * [TicketPrice]
Transcribed Image Text:Helicopter HelicopterID HelicopterName HelicopterModel SeatingCap Hourly Cost DateLastMaint 1(1, 1) Takes M/(0, N) Trip TripID HelicopterID PilotID Tour TypeID TripDate StartTime NumPeople M (0, N) M (0, N) Belongs to Controls Tour Type Tour TypeID Tour TypeName ExpectedHours TicketPrice (1, 1) 1 (1,1) Pilot PilotID SSN FirstName LastName Street City State ZipCode Phone Date of Birth Which of the following options most correctly expresses the equation to generate a new variable: "TicketSales" to compute the overall ticket sales, using data from the Trip table and the TourType table? (as you would type in the expression builder) O TicketSales: [Trip] * [TourType] O TicketSales: [Trip]![NumPeople] * [TourType]![TicketPrice] TicketSales= [Trip]! [NumPeople] * [TourType]![TicketPrice] O TicketSales: [TourType]! [NumPeople] * [Trip]![TicketPrice] TicketSales: [Num People] * [TicketPrice]
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Table
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
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education