Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose that there are three relationships in a database: Student relationship: S(SNO, SNAME, AGE, GENDER, DEPT) Enroll relationship: SC(SNO, CNO, GRADE) Course relationship: C(CNO, CNAME)

Suppose that there are three relationships in a database:

Student relationship: S(SNO, SNAME, AGE, GENDER, DEPT)

Enroll relationship: SC(SNO, CNO, GRADE)

Course relationship: C(CNO, CNAME)

Here, the abbreviation and their full name correspond as:

SNO

Student Id number

DEPT

Student department

SNAME

Student name

CNO

Course number

AGE

Student age

GRADE

Course grade for certain student

GENDER

Student gender

CNAME

Course name

Query the following in T-SQL format:

  1. Query the id number, name, and age of the students who did not enroll C2 course.
  2. Query the names of the students who enrolled all of the courses.
  3. Query all of the id number and name of the students who enrolled the courses that were also enrolled by student whose id number is S3.
  4. Query all of the id number, name, gender, and department of the students who did not enroll in Network Admin w TCP/IP course.
  5. Query all of the id number and name of the male students whose grade is 80-90 in the course of SQL and NoSQL.

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

Hands On Database

Authors: Steve Conger

1st Edition

013610827X, 978-0136108276

More Books

Students also viewed these Databases questions

Question

Describe effectiveness of reading at night?

Answered: 1 week ago

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago