Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Schema flight (flightNumber, airlinecode, date price, seating, IATA, IATALands, time, timeland) customer (name, phone, agentName) agent (name, fee, phone) airport (IATA, city, type) booking (

image text in transcribedimage text in transcribedimage text in transcribed

Schema flight (flightNumber, airlinecode, date price, seating, IATA, IATALands, time, timeland) customer (name, phone, agentName) agent (name, fee, phone) airport (IATA, city, type) booking ( name, flightNumber, airlinecode, date seat) Customer Phone name agentName seat price Aline Sean John Booking name flight airline Date Nber ode Tom AA 207 3.4.21 Bill UA 146 3.4.21 Sarah MEA 205 3.4.21 Airport IATA City ORD Chicago MDW Boston BOS Boston A1 140 A3 345 4 560 agent Name Aline Sean John 8899452552 Tom 7814449884 Bill 7753698887 Sarah Agent agentName Price Aline 150 Sean 460 John 150 Flight flightNumber airlinecode 207 UA 146 MEA 205 phone 7785667860 7834438765 9873434444 Type International International International Price 200 400 250 Seat 5 11 4 IATA IATALands BOS EWR ERW MCO FRA BEY timeDep. 12:00 14:00 12:00 Time Arr 13:05 18:05 13:05 date 3.4.21 3.4.21 3.4.21 ER diagram below shows a flight management system allows viewing flight information and booking flights. The flight includes the airline code, flight number, price, seating. Each flight takes off and lands in an airport. The airport has IATA (unique code), city, and type. A customer has a name and a phone. An agent takes care of customers. Each agent has a name and a booking fee. Airport takeoff flight airline Code flightNumber time Price Seating City Type time seat land booking time Customer Name phone Agent Name fee Takecare Write a SQL expression that returns the average price of items bought by each customer from each agent

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke

1st Edition

0130086509, 978-0130086501

Students also viewed these Databases questions

Question

7. How will you encourage her to report back on the findings?

Answered: 1 week ago

Question

If ( A^2 - A + I = 0 ), then inverse of matrix ( A ) is?

Answered: 1 week ago

Question

What is computer neworking ?

Answered: 1 week ago

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago