Answer Happy

The relational database schema below is a part of a University database schema, where each student has at most one tutor and each course has at most one class representative. CREATE DOMAIN StudldDomain AS int CHECK (VALUE >= 30000000 AND VALUE =< 300099999); CREATE DOMAIN CharDomain AS char(15); CREATE DOMAIN PointDomain AS int CHECK (VALUE BETWEEN O AND 1000); CREATE TABLE Student StudentId StudIdDomain PRIMARY KEY, Name CharDomain NOT NULL, NoOfPts Point Domain NOT NULL. Tutor StudidDomain REFERENCES Student (Studentld) ); CREATE TABLE Course Courseld CharDomain PRIMARY KEY. CourName CharDomain, ClassRep StudldDomain REFERENCES Student(Studentld) ); CREATE TABLE Enrolled StudentId StudentIdDomain NOT NULL REFERENCES Student, Courseld CharDomain NOT NULL REFERENCES Course, In TermPts PointDomain NOT NULL, PRIMARY KEY (StudentID, Courseld) ); Write SQL queries and Algebra expressions for the database above to do the following: Retrieve details of courses that have more than 50 students enrolled in it. SOL: Algebra: