Back to the 2025 paper
Similar questions
DATABASE MANAGEMENT SYSTEMWhich join refers to join records from the right table that have no matching key in the left table and are included in the result set? - (i) Left outer join (i) Right outer join (iii) Full outer join (iv) Half outer join20212mDatabase Management SystemWhat is the use of relational query language in DBMS? Use the example to explain tuple and domain relational calculus.20207mDATABASE MANAGEMENT SYSTEMWhich of the following is the original purpose of SQL? - (i) To specify the syntax and semantics of SQL data definition language (ii) To specify the syntax and semantics of SQL manipulation language (ii) To define the data structures (iv) All of the above20212mDatabase Management SystemWhat are multivalued and join dependencies in the database system? Explain with the help of example.20187m
PreviousDesign an ER diagram for a Hospital Management System containing Patients, Doctors, Departments, and Appointments. Clearly identify entities, attributes, relationships, and cardinalities.NextConsider: * 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: * \pi_{Name}(\sigma_{Marks > 85}(Student \bowtie Enroll))