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 SQL 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started