Question
Database Schema STUDENT(SID, Name, Maior, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SlD, Course#, Quarter, Grade) i. Write DDL statements to create relations STUDENT, COURSE and ENROLL as
Database Schema STUDENT(SID, Name, Maior, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SlD, Course#, Quarter, Grade) i. Write DDL statements to create relations STUDENT, COURSE and ENROLL as given in the above database schema in question Q3a. ii. Write the SQL statement to insert the data in the above created tables. iii. Write SQL statement to display the name of all the courses, which are not enrolled by any student (consider the database schema of Q3a). iv. Write the SQL statement to update the grade with 'A' whose SID is 105for the above database schema in question Q3a. v. Write SQL statement to display the name and SID of all of all students who are enrolled to both 'Database' and'Operating System' courses(consider the database schema of Q3a). vi. Write SQL statement to display the name ofstudentsin decreasing order (consider the database schema of Q3a). vii. Write SQL statement to display the name, SID and Gradeof studentsgroup by grade (consider the database schema of Q3a).
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