Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Informix Database Administrators Survival Guide

Authors: Joe Lumbley

1st Edition

0131243144, 978-0131243149

More Books

Students also viewed these Databases questions

Question

what is a peer Group? Importance?

Answered: 1 week ago