The entity relationship diagram below models the components of a database belonging to the South African Film Writers' Association. The database allows SAFWA to keep track of movies filmed in South Africa, developed by domestic and international studios. The MS Access database diagram below shows the tables created for a travel agent company called TravelSpace. They implemented their database to keep track of their customer's bookings for the different trips they have available. The company offers multiple tours which can be booked by many different customers. Given the diagram below, answer the following questions by providing SQL statements. CUSTOMER BOOKING TOUR BOOKING 1OURD T BOOKNG NO TOUR DATE CUST NO CUST PNAME CUST UNAme CUST ADDRESS CUST DOB CUST EMA our AT NO INSEAT NO CUST PHONE soOKNG NO TOUR I TOURO TOUR NAME TOURLDESCRIPON TOUR PRICE ADT TOUR PRICE OHLD TOUR PRICE CON HOTELD FIGHT NO BOOKTOTAL COST BOOENG DATE 6.1 Write the SQL statement used to CREATE the TOUR_BOOKING table. 6.2 Count how many tours are offered by TravelSpace. Count only the tours whose adult price is over R5000. 6.3 List all customers' names (first and last name) and their booking information (booking number, date and status code). Make use of an INNER JOIN.
The entity relationship diagram below models the components of a database belonging to the South African Film Writers' Association. The database allows SAFWA to keep track of movies filmed in South Africa, developed by domestic and international studios. The MS Access database diagram below shows the tables created for a travel agent company called TravelSpace. They implemented their database to keep track of their customer's bookings for the different trips they have available. The company offers multiple tours which can be booked by many different customers. Given the diagram below, answer the following questions by providing SQL statements. CUSTOMER BOOKING TOUR BOOKING 1OURD T BOOKNG NO TOUR DATE CUST NO CUST PNAME CUST UNAme CUST ADDRESS CUST DOB CUST EMA our AT NO INSEAT NO CUST PHONE soOKNG NO TOUR I TOURO TOUR NAME TOURLDESCRIPON TOUR PRICE ADT TOUR PRICE OHLD TOUR PRICE CON HOTELD FIGHT NO BOOKTOTAL COST BOOENG DATE 6.1 Write the SQL statement used to CREATE the TOUR_BOOKING table. 6.2 Count how many tours are offered by TravelSpace. Count only the tours whose adult price is over R5000. 6.3 List all customers' names (first and last name) and their booking information (booking number, date and status code). Make use of an INNER JOIN.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
Transcribed Image Text:The entity relationship diagram below models the components of a database belonging to the
South African Film Writers' Association. The database allows SAFWA to keep track of movies
filmed in South Africa, developed by domestic and international studios.
The MS Access database diagram below shows the tables created for a travel agent company
called TravelSpace. They implemented their database to keep track of their customer's bookings
for the different trips they have available. The company offers multiple tours which can be booked
by many different customers. Given the diagram below, answer the following questions by
providing SQL statements.
CUSTOMER
BOOKING
CUST NO
CUST FNAME
BOOKNG NO
TOUR BOOKING
EMP ID
CUST NO
BOOK STATUS CODE
7 TOUR ID
7 80OENG NO
TOUR DATE
TOUR
CUST LNAme
CUST ADORESS
CUST DOB
CUST EMAIL
OUT SEAT NO
IN SEAT NO
CUST, PHONE
1 TOURO
TOUR NAME
TOUR DESCRIPTON
EVENTJD
HOTEL_D
TOUR PRICE ADULT
FUGHT NO
BOOK, TOTAL, COST
BOOKNG DATE
TOUR PRICE CHILD
TOUR, PRICE CON
6.1 Write the SQL statement used to CREATE the TOUR_BOOKING table.
6.2 Count how many tours are offered by TravelSpace. Count only the tours whose adult
price is over R5000.
6.3 List all customers' names (first and last name) and their booking information (booking
number, date and status code). Make use of an INNER JOIN.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY