Question: Specify the following queries in SQL on the database schema in Figure 1.2. a. Retrieve the names and major departments of all straight-A students (students

Specify the following queries in SQL on the database schema in Figure 1.2.

a. Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their courses).

b. Retrieve the names and major departments of all students who do not have a grade of A in any of their courses.

*****This is exercise 7.6 from textbook "Fundamentals of Database Systems 7th Edition" by Elmasri and Navathe*****

Specify the following queries in SQL on the database schema in Figure

STUDENT Name Student_numberClass Smith CS CS COURSE Course_name Course_number Credit hours Department Intro to Computer Science CS1310 Data Structures Discrete Mathematics CS3320 MATH2410 CS3380 CS CS MATH CS SECTION Section_identifier Course_numberSemester Year 85 92 102 112 119 135 MATH2410 CS1310 CS3320 MATH2410 CS1310 CS3380 07 King 07 Anderson 08 Knuth 08 08 Anderson 08 Stone Fall Spring Chang Fall GRADE REPORT 112 119 85 92 102 135 17 17 PREREQUISITE Course number CS3380 CS3380 CS3320 e number CS3320 MATH2410 CS1310

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!

yes Specify the structure of the database. provide the tables." yes" yes add sheama 6:12. Specify the following queries in SQL on the database schema of Figure 1.2. a. Retrieve the names of all...

7.5 - Specify the following additional queries on the database of Figure 5.5 in SQL. Show the query results if applied to the database of Figure 5.6. (a) For each department whose average employee...

Specify the following queries in SQL on the database schema of Figure 1.2. (a) Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their...

Specify the following queries in SQL on the database schema of Figure 1.2. (a) Retrieve the names of all senior students majoring in 'COSC' (computer science). (b) Retrieve the names of all courses...

6.12 Specify the following queries in SQL on the database schema of Figure 1.2 (a) Retrieve the names of all senior students majoring in CS (computer science). (b) Retrieve the names of all courses...

6.12. Specify the following queries in SQL on the database schema of Figure 1.2. a. Retrieve the names of all senior students majoring in "es" (computer science) b. Retrieve the names of all courses...

6.11. Specify the updates of Exercise 3.11 using the SQL update commands. 6.12. Specify the following queries in SQL on the database schema of Figure 1.2. a. Retrieve the names of all senior students...

a) Specify the following queries in SQL on the database schema of Figure 1.2. a. Retrieve the name of each course and the instructor who taught that course. If an instructor taught a course more than...

4.12 Specify the following queries in SQL on the database schema of Figure 1.2 a. Retrieve the names of all senior students majoring in 'CS (computer sci- b. Retrieve the names of all courses taught...

What critical terms related to the ADA must be considered in evaluating the legal implications of Daves decision? How do they apply in this case?

Let R be the rectangle with vertices (1, 1), (1. 4), (3, 1), and (3, 4). Let f be the shear in the x-direction with k = 3. Find and sketch the image of R.

The price - earnings ratio of a firm with substamial growth opporturities is given by the expression Ir denotes the discount rate on the frem's rtock, and NPVGO denotes the net present value of...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

=+fully fund the war effort; to make up this difference, the colonies decided to print more money. Printing money to cover expenditures is sometimes referred to as an inflation tax. Who do

=+Who do you suppose benefits from the higher productivity? Is society getting a free lunch?

=+14. Suppose Americans decide to save more of their incomes. If banks lend this extra savings to businesses, which use the funds to build new factories,