Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the Relational Database: STUDENT [ sID , sName, GPA, sizeHS] APPLY [ sID , cName , Major, Decision] COLLEGE [ CName , State] where

Consider the Relational Database: STUDENT [sID, sName, GPA, sizeHS] APPLY [ sID, cName, Major, Decision] COLLEGE [CName, State]

where APPLY.sID REFERENCES STUDENT.sID and APPLY.cName REFERENCES COLLEGE.CName

Using SQL queries to find:

a. The list of students who applied for at least all the colleges that the student sID = "2" did (using division or double negation).

b. The list of colleges that all the students in the STUDENT table applied in.

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

How To Build A Million Dollar Database

Authors: Michelle Bergquist

1st Edition

0615246842, 978-0615246840

More Books

Students also viewed these Databases questions

Question

2. Discuss the steps in preparing a manager to go overseas.

Answered: 1 week ago