Page 1 of 1
Problem 2. A university database contains the following relations: STUDENTS (Sno: integer, Sname: string, Sdept: string,
Posted: Thu Feb 17, 2022 10:58 am
by answerhappygod
- Problem 2 A University Database Contains The Following Relations Students Sno Integer Sname String Sdept String 1 (24.45 KiB) Viewed 53 times
Problem 2. A university database contains the following relations: STUDENTS (Sno: integer, Sname: string, Sdept: string, Age: integer) COURSES (Cno: integer, Cname: string) ENROLLMENT (Sno: integer, Cno:integer, Grade: integer) Write the following queries in relational algebra: (1) Find the Sno and course grades for students who take "OS" or "DBMS". (2) Find the Sno of students whose courses include all courses taken by the student with Sno = 10. (3) Find the Sname and Sdept for all the students who do not enroll in the course with Cno = 3.