Deptmaster (deptid,deptname, dlocation), coursemaster (deptid, courseid, coursename), strengthmaster (deptid, courseid, maxstudentallow), studentdetails (deptid,courseid, studno, studname);

Question

1) display the department and course where maximum students registered

2) select name, department and course of student whose name begin with 'A'

3) display department name of student having student number 1

Answer 1

I've renamed the table for convenience

Dept (did, dname, dlocation)

Course (did, cid, cname)

Strength (did, cid, maxstudentallow)

StudentDetails (did, cid, studno, studname)

1) display the department and course where maximum students registered

SELECT dname, cname FROM Dept, Course, Strength WHERE Dept.did = Course.did AND Dept.did = Strength.did AND Course.cid = Strength.cid AND maxstudentallow >= ALL (SELECT maxstudentallow FROM Strength)

2) select name, department and course of student whose name begin with 'A'

SELECT studname, dname, cname FROM Dept, Course, StudentDetails WHERE Dept.did = Course.did AND Dept.did = StudentDetails.did AND Course.cid = StudentDetails.cid AND studname LIKE 'A%'

3) display department name of student having student number 1

SELECT dname FROM Dept, StudentDetails WHERE Dept.did = StudentDetails.did AND studno = 1