Problem 2. A university database contains the following relations: STUDENTS (Sno: integer, Sname: string, Sdept: string,

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Problem 2. A university database contains the following relations: STUDENTS (Sno: integer, Sname: string, Sdept: string,

Post by answerhappygod »

Problem 2 A University Database Contains The Following Relations Students Sno Integer Sname String Sdept String 1
Problem 2 A University Database Contains The Following Relations Students Sno Integer Sname String Sdept String 1 (24.45 KiB) Viewed 51 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”