PyQdeck LogoPyQdeckSubjects
Back to the 2025 paper

Module 2: Relational Query Languages & Design

202510m

Consider:

  • Student(SID, Name, Dept, Age)
  • Course(CID, CName, Faculty)
  • Enroll(SID, CID, Marks)
  1. Write relational algebra expressions to find:
    • a) Students enrolled in DBMS
    • b) Students scoring >80 marks
    • c) Students not enrolled in any course
  2. Write SQL queries:
    • a) Find highest marks
    • b) Find average marks department-wise
    • c) Display students enrolled in more than two courses
  3. Translate the following query into tuple relational calculus:
    • "Find names of students from CSE department."
  4. Convert the following relational algebra into SQL:
    • πName(σMarks>85(Student⋈Enroll))\pi_{Name}(\sigma_{Marks > 85}(Student \bowtie Enroll))
Search GoogleAsk AI

Similar questions

Database Management SystemConsider the following schema for institute library: Student (RollNo, Name, Father_Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (RollNo, ISBN, Date-of-Issue) Write the following queries in SQL and relational algebra: (i) List roll number and name of all students of the branch 'CSE'. (ii) Find the name of student who has issued a book published by 'ABC' publisher. (iii) List title of all books and their authors issued to a student 'RAM'. (iv) List title of all books issued on or before December 1, 2020. (v) List all books published by publisher 'ABC'20247mDatabase Management SystemWhich query is best solved using division operation? (i) Find students enrolled in DBMS (ii) Find students enrolled in all courses (iii) Find students with marks >80 (iv) Find students from CSE20252mDatabase Management SystemGiven the Students' relation as shown below: | StudentID | StudentName | StudentE-mail | StudentAge | CPI | |---|---|---|---|---| | 2345 | Shankar | shankar@math | X | 9.4 | | 1287 | Swati | swati@ee | 19 | 9.5 | | 7853 | Shankar | shankar@cse | 19 | 9.4 | | 9876 | Swati | swati@mech | 18 | 9.3 | | 8765 | Ganesh | ganesh@civil | 19 | 8.7 | For (StudentName, StudentAge) to be the key for this instance, the value X should not be equal to: (i) 18 (ii) 19 (iii) 15 (iv) 2020192mDATABASE MANAGEMENT SYSTEMDifference between Relational Algebra & Calculus.20247m
PreviousWhat is a JOIN in SQL? Explain various JOIN operations with a suitable example for each and discuss their applications in database systems.NextFor relation R(A,B,C,D,E) functional dependencies are given as follows: * A \rightarrow BC * CD \rightarrow E * B \rightarrow D Find candidate keys.