Back to the 2025 paper
Similar questions
Database Management SystemWhat are multivalued and join dependencies in the database system? Explain with the help of example.20187mDatabase Management SystemExplain the select, project, join and division with the help of example.20187mDatabase Management SystemExplain the following operations with the help of examples: (i) Generalized projection (ii) Outer join (iii) Aggregate function20207mDATABASE MANAGEMENT SYSTEMExplain the following operations with the help of examples: - (i) Set of intersection operation (ii) Natural join operation (iii) Division operation20217m
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))
Budget AppAndroid App
Pocketly on Android
Log daily food, travel, and hostel expenses instantly. Set monthly spending limits and see where your money goes without complex spreadsheets.