Question: Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber , CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the

Given the following relational database schema:

Student = (SSN, Name, Major)

Course = ( CourseNumber , CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00.

Enrollment = (SSN , CourseNumber, Grade)

Express the following queries using AQL statements with minimum number of tables and operations.

a. List the SSN and Name of every student who has no grade in at least one course.

b. List the name of every student who enrolled in at least two courses.

c. List the name of every student who hasnt taken any course.

d. List the SSN and the name of every student who does not have a grade in any course, i.e all her or his grades are null.

e. List the SSN and Name of all students who do not have the grade A in any course.

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:

Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber , CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00....

Q:

Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber , CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00....

Q:

Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber , CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00....

Q:

Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber , CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00....

Q:

How would I go about this question without the use of COUNT(*), I was able to reach the solution easily using it but I'm struggling with doing it without the use of COUNT(*) Given the following...

Q:

Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber , CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00....

Q:

Given the following relational database schema: Student = ( SSN , Name, Major) Course = ( CourseNumber , CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00....

Q:

Given the following relational database schema: Student = ( SSN , Name, Major ) Course = ( CourseNumber, Quarter, CourseTitle, NumberOfUnits, RoomNumber, DayTime ) , where DayTime is of the form MW 1...

Q:

Given the following relational database schema: Student = ( SSN , Name, Major ) Course = ( CourseNumber, Quarter, CourseTitle, NumberOfUnits, RoomNumber, DayTime ) , where DayTime is of the form MW 1...

Q:

Given a relational schema: (in SQL ) 1. List every two CourseNumber and their titles which ahve the same prerequisites. 2. List the name of every student and SSN who has completed all the courses...

Q:

You are purchasing a new machine that costs $13 million, and that has a 9 year expected life span. After 9 years, the estimated salvage value is $3 million. What is the yearly straight-line...

Q:

Assume you are a middle manager in charge of a plan to increase inter-professional collaboration in your hospital. Use the eight best practices for building a successful Clinical Integration (CI)...

Q:

what role does the iSCSI initiator play in establishing a connection to an iSCSI target?

Q:

What challenges is IMAX corporation facing that are causing it to consider expanding yo BRIC countries

Q:

C Does avoiding saying (or printing) the word give it more or less power?

Q:

A What meaning does the N-word carry for you? Does it seem appropriate to use it in a scholarly discussion? How do you feel about its being printed (or not printed) in this textbook?

Q:

What are your personal thoughts on sex, gender, and language? Do you think men and women speak different languages, or do you feel that we all speak more similarly than differently? How do your...