Std Enrolls Sec SID 1003 Eshaan Barry CID SECID GRADE 1002 1045 2 CID schema is: Student (SID SName) Course (CID, CName) Course_Section (CID, SecID SType)... Assume we implemented the following mini-database Student SID SNAME Course Section SECID Pos get Course CNAME CID STYPE Sta 1030 1 Reg 1030 2 Reg 0 1480 Networking 1000 Chinmaya Mahapatra 1045 1 WWW 1000 1045 1 0 2221 Database Systems 1005 Jack Lei 1045 2 WWW 1002 1045 1 70 1045 Web Programming 1001 Iris Chang 1045 1000 1030 1 95 1050 Intro to Computers 1002 Jocelyn Bowes 1045 1000 1480 3 97 1004 Jagmeet Singh 1030 Web Development 1045 1000 1480 2 75 1006 Rodrigo Ferrara 1280 Linux Systems 1050 3457 WWW WWW Reg 1 WWW 1000 1050 1002 1050 1 1 98 1280 1 www 90 1280 2 N 1002 1280 2 Reg 45 1480 1 www 1002 1480 3 72 1480 2 WWW 1003 1045 4 65 1480 3 WWW 1003 1480 3 79 1001 1030 1 75 1001 1280 2 40 1000 1045 2 0 1000 1045 3 90 1000 1045 4 90 1000 1045 5 95 1000 1030 2 95 1000 1480 1 99 1000 1280 1 75 1001 1045 3 75 1000 1280 2 100 Relational database schema is: Student (SID, SName) Course (CID, CName) Course Section (CID, SecID, SType) Std Enrolles Sec (SID, (CID, SecID), Grade) COURSE (C) CID CName STUDENT(S) SID SName Grade M Enrolls has N SECTION (SC) SecID Exercise (2.5 Marks Each]: Each Question needs to have a Query in text format and a screenshot of the solution. Tables is to be created and Data either needs to be inserted or imported after creating CSV file (download from Moodle). Without this, the the queries with the screenshots is impossible. Q1: Display the name of students who enrolled in at least one section. Q2: Retrieve Course ID, section ID, and Section Type of the sections that have been enrolled by at least one student Q3: Display CIS, SecID, and SType of all sections (no matter if a student has enrolled in that section or not) and the name of students who enrolled in that section. Q4: Display the name of all students (no matter if they have enrolled in any section) and the section number of all sections that they have enrolled. Q5: Display the name of all students and all sections they have enrolled (no matter if a student has enrolled in any section and no matter if a section was enrolled by any student) Q6: Display the name of student who have not enrolled in any section? Q7: Display the name of section which has not be enrolled by any student? Q8: Retrieve the name of student and number of sections that they have enrolled Q9: Retrieve the name of students who have taken all courses Q10: Retrieve the CID of courses and the number of students who enrolled in those sections Q11: Retrieve the name of students who are classmates with 'Chinmaya Mahapatra' in all sections that he has enrolled. Q12: Retrieve the name of all students who enrolled in 1045-001