FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use relational algebra to answer the following queries. (a) List the names, phones and current level id of all swimmers with current level id >3.

Use relational algebra to answer the following queries.

image text in transcribed

(a) List the names, phones and current level id of all swimmers with current level id >3. LNameEName Phone currentLeveild I Khan Bobby 832-116-2992I I Johnson I Clara 713-222-1010I (b) List the names and level's names of the swimmers with the last name 'Khan'. I LName FName I level I Khan Bobby Yellow I I Khan Billy BlueI Khan Nina BlueI (c) List the swimmer names who have participated in the event '50M Butterfly' of the meet 'UHCL Open'. I LName IFName Khan I Billy Khan I Nina I I Johnson | Philip

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

Visual Basic6 Database Programming

Visual Basic6 Database Programming

Authors: John W. Fronckowiak, David J. Helda

1st Edition

0764532545, 978-0764532542

More Books

Students also viewed these Databases questions

Question

★★★★★
Draw the free body diagrams of the two spur gears shown in Figure. Use the resulting equations of motion to show that T2 = NT1 if the gear inertias are negligible or if there is zero acceleration....

Answered: 1 week ago

Question

★★★★★
=+2. In a certain chemical process the reaction time y (hr) is known to be related according to the simple linear regression model to the temperature x (F) in the chamber in which the reaction takes...

Answered: 1 week ago

Question

★★★★★
=+ (c) Exhibit (0,1) - K as a disjoint union of open intervals /, [A12]; define g as f on K, and define it by linear interpolation on each / ..

Answered: 1 week ago

Question

★★★★★
On Brenda Sniezeks first day of work for the Kansas City Chiefs Football Club, she signed a document that purported to compel arbitration of any disputes that she might have with the Chiefs. In the...

Answered: 1 week ago

Question

★★★★★
Consider a call option on a stock, the stock price is $23, the strike price is $20, the continuously risk-free interest rate is 9% per annum, the volatility is 39% per annum and the time to maturity...

Answered: 1 week ago

Question

★★★★★
An investment promises a series of $19,000 annual cash flows in each of the next 5 years. The first cash flow occurs one year from today. What is the maximum amount a rational investor would pay for...

Answered: 1 week ago

Question

★★★★★
A die is rolled and value is recorded. The table shows the results of 20 rolls. 1 5 5 2 5 1 5 65 2 LQ 5 LO 5 2462 6 33 5 2 2 (a) Complete the probability distribution table. X P(X) 1

Answered: 1 week ago

Question

★★★★★
Uncle Cosmo plans to build a factory. It will cost $ 1 , 0 0 0 , 0 0 0 . He expects the after - tax cash inflows to be $ 2 3 0 , 0 0 0 annually for 6 years, after which he plans to scrap the...

Answered: 1 week ago

Question

★★★★★
The amount of pollutants that are found in waterways near large cities is normally distributed with mean 9 ppm and standard deviation 1.3 ppm. 38 randomly selected large cities are studied. Round all...

Answered: 1 week ago

Question

★★★★★
Your faculty member will divide the class into teams. Each team will select a specific organization they will be developing the security program for a hospital, college, government building, or...

Answered: 1 week ago

Question

★★★★★
2. You are working for a glider manufacturer and have been asked to analyse the laminar boundary layer at a certain point on the smooth wing. The velocity profile at this point, u(y), is given by: u...

Answered: 1 week ago

Question

★★★★★
3 What kinds of presentations do you think would work best as podcasts? What kinds would not work well? Are podcasts useful outside academia?

Answered: 1 week ago

Question

★★★★★
Consider your specific speech purposewhat are your objectives for your informative speech? Now consider what types of presentation aids might help you achieve your purpose. How might you use aids to...

Answered: 1 week ago

Question

★★★★★
2 Imagine that you have to give an informative speech about a sexual topic in front of your nursing class. How would you approach the subject? Would you handle it differently if you were speaking in...

Answered: 1 week ago

Previous Question Next Question