Question: Consider the SQL query whose answer is shown in Figure 3.2. Sid Name Login Age Gpa 53831 Madayan

Consider the SQL query whose answer is shown in Figure 3.2.
Sid
Name
Login
Age
Gpa
53831
Madayan
madayan@
11
1.8
53832
Gulda
guldu@music
12
2.0
Students with age < 18 on Instance S
1. Modify this query so that only the login column is included in the answer.
2. If the clause WHERE S.gpa > = 2 is added to the original query, what is the set of tuples in the answer?

Step by Step Solution

★★★★★

3.51 Rating (188 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The answers are as follows 1 Onl... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

960-C-S-D (2428).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the SQL query select p.a1 from p, r1, r2 where p.a1 = r1.a1 or p.a1 = r2.a1. Under what conditions does the preceding query select values of p.a1 that are either in r1 or in r2? Examine...

Consider the SQL query in Figure 1-19. a. How is Sales to Date calculated? b. How would the query have to change if Helen Jarvis wanted to see the results for all of the product lines, not just the...

Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. What are the referential integrity constraints that should hold on the schema? Write appropriate SQL DDL statements to...

(25 points) Questionl Consider the following instance of the Students relation, sorted by age. Assume that these tuples are stored in a sorted file in the order shown; the first tuple is on page 1,...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

Please do not copy other solutions. Thank you very much in advance! Product(pname, maker, price). Consider the SQL query: SELECT c.cname, c.president FROM Company c, Product p WHERE (c.cname-p.maker)...

Consider an SQL query that has a Window function with an ORDER BY inside the OVER clause, and an ORDER BY in the main query like this: SELECT product _ id , sale _ date, amount _ sold, SUM ( amount _...

( b ) Consider the SQL query shown in Table 1 . ( i ) Draw a near - optimal query tree for the SQL query. ( ii ) Identify the root and leaf nodes in the tree that you drew for part ( i ) . ( iii )...

a. What will be the field size for the ProductLineName field in the Product table? Why? b. In Figure 1-19, how is the ProductID field in the Prod. uct table specified to be required? Why is it a...

Consider the SQL query below that operates on the table emp containing attributes ( empld , nam gender, salary, deptld ) : select deptld, count ( * ) from emp where gender = "female" and salary > (...

A company currently pays a dividend of $1.4 per share (D 0 = $1.4). It is estimated that the companys dividend will grow at a rate of 20% per year for the next 2 years, and then at a constant rate of...

Cornish Company has the following shareholders equity at 1/1/Year2. Assume Cornish acquired all of the treasury stock in a single transaction during Year1. Some of the treasury share were reissued...

Which of these is NOT one of the two basic types of cryptography? a . Symmetric b . Asymmetric c . Forward d . None of the above

Suppose a typical automobile tire cost $50 in the base year and had a useful life of 40,000 miles. Ten years later, the typical automobile tire cost $75 and had a useful life of 75,000 miles. If no...

Do you think that the single-file redundancy problem is more serious, less serious, or about the same as the multifile redundancy problem? Why?

In your own words, describe the key quality of a DBMS that sets it apart from other data handling systems.

Describe the purpose of the GROUP BY clause. Why must the attribute in the GROUP BY clause also appear in the SELECT clause?

1 2 . 1 2 LAB * : Warm up: Online shopping cart ( Part 1 ) ( 1 ) Build the ItemToPurchase class with the following specifications: Attributes ( 3 pts ) item _ name ( string ) item _ price ( float )...

Consider the following information about three stocks; If your portfolio is invested 40 percent each in A and B and 20 percent in C, what is the portfolio expected return? The variance? The standard...

The NuPress Valet Co. has an improved version of its hotel stand. The investment cost is expected to be $72 million and will return $13.5 million for 5 years in net cash flows. The ratio of debt to...