Question: 2 . ( 4 0 marks ) Consider these three relations and then write SQL statements to answer the questions that follow. TRAVEL _ AGENT

2.(40 marks) Consider these three relations and then write SQL statements to answer the questions that follow.
TRAVEL_AGENT (TA_no, name, age, salary)
CUSTOMER (C_ID, name, departure_city, destination, journey_class)
TRANSACTION (number, C_ID, TA_no, date, amount_paid)
a. Compute the number of different customers who have a transaction

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Consider the following three relations: TRAVEL_AGENT (name, age, salary) CUSTOMER (name, departure_city, destination, journey_class) TRANSACTION (number, cust_name, travel_agent_name, amount_paid)...

Q:

Code the function greedy_predicator without using numpy/pandas Please include explanation of the code & the computational complexity To see the description of the function: Scroll down the...

Q:

Practice Section You may want to download and open the Practice Database in Lesson 4 in Microsoft Access (Admissions Student Database.mdb; Please note that this database is graciously provided...

Q:

Task 6 - Retail Inventory System [ 3 marks ] You are tasked with handling transactions in a retail inventory system that tracks product stock and customer orders. a . Create a database named RetailDB...

Q:

Hi tutors, I have attached a few images of these questions. Please help me solve these question. Thank you. I am in a real rush. Thanks. Much appreciated. :) (a) Consider a 'user-vaccine' database...

Q:

There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...

Q:

Consider the following three relations: TRAVEL_AGENT (name, age, salary) CUSTOMER (name, departure_city, destination, journey_class) TRANSACTION (number, cust_name, travel_agent_name, amount_paid)...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Q:

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Q:

List some examples in each of the following specialized AIS. AIS for a particular industry or niche within an industry: AIS with add-on modules for special needs: Integrated AIS/Executive Suite type...

Q:

Lena is 66 years of age, single, and blind. She is not claimed as a dependent by any other person. How much gross income must she have before she is required to file a Federal income tax return for...

Q:

Please answer ( a ) through ( g ) . Neighborhood Insurance sells fire insurance policies to local homeowners. The premium is $ 1 2 0 , the probability of a fire is 0 . 1 % , and in the event of a...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

4. What do you know about the healthcare industry and electronic medical records? Have you ever worked with medical record systems and software? What work did you do with them?

Q:

Data management, analytics, and information system experience preferred

Q:

1. Have you worked with any business intelligence software? Which tools? What is your level of proficiency? Can you give examples of the kinds of data analysis work and reports you used these tools...