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

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter7: Creating Templates, Importing Data, And Working With Smartart, Images, And Screenshots
Section: Chapter Questions
Problem 4EYK
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
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L