Answer Q4 USe MySQL and do it on terminal . post the photos of commands and output and paste the commands also

Q3. Consider the following relation: Student Enroll Rno Name Rno cno 1902001 Akash 1902001 98 1902002 Nishant 1902002 99 1902003 Vivek 1902004 100 1902004 Gaurav 1902005 101 1902005 Ankita 1902007 98 1902006 Nandini 1902006 99 1902007 Mridul Course cno C name 98 DBMS I 99 COA 100 CN 101 PL a. Insert necessary tables in the relational database with sql statements. b. Find the names of the students who enrolled in a course with course number 99. (hint: use exists clause with sub queries). Q4. Add the following table with the above tables in 04: Student Details (Rno, Branch, Year, Passport, Marks) Stud t Details Rno Branch Year Passport Marks 1902001 CSE 1 20 1902002 CSE 1 yes 30 1902003 ECE 1 10 1902004 CSE 2 yes 50 1902005 ME 4 - 10 1902006 ECE 3 yes 15 1902007 Civil 4 yes 25 Note: insert null where blank given. a. Find all the names of students who have no passport. b. Find all the names of students of CSE, ECE,ME. c. Find all the names of students other than CSE (write efficient query for this). d. Find all the names of students whose marks are above 10 and below 20