Answered step by step
Verified Expert Solution
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 |
Please read the questions carefully and write the following queries in T-SQL format (No need to execute each query).
- Query the id number and the grade of the students who enrolled the course whose course number is C2.
- Query the id number and the name of the students who enrolled the course whose course number is C2.
- Query the id number and the name of the students who enrolled the course whose name is SQL and NoSQL.
- Query the id number of the student who enrolled C2 or C4 course.
- Query the id number of the students who at least enrolled C2 and C4 courses.
- Query the id number, name, and age of the students who did not enroll C2 course.
- Query the names of the students who enrolled all of the courses.
- 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.
- Query all of the id number, name, gender, and department of the students who did not enroll in Network Admin w TCP/IP course.
- 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
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