For the Course Registry database given below –
Students(snum, sname, major, standing, age, gpa)
Faculty(fid, fname, deptid)
Courses(cnum, cname, course_level, credits)
Offerings(onum, cnum, day, starttime, endtime, room,max_occupancy, fid)
Enrolled(snum, onum)
Write the Relational Algebra (RA), Tuple Relational Calculus(TRC), and Domain Relational Calculus (DRC) whichever is labelledagainst the question. Note that some of these queries might not beexpressible in Relational Algebra, QBE, or Relational Calculus. Forsuch queries, informally explain why they cannot be expressed.
2. (RA,TRC,DRC,QBE) Find the names of students who are notenrolled in any course.
Expert Answer
An answer will be send to you shortly. . . . .