Back to the 2020 paper
Similar questions
Software EngineeringDraw the first two levels of DFDs for an 'Online Examination System'. Make necessary assumptions.20217mDatabase Management SystemDesign an ER diagram for a Hospital Management System containing Patients, Doctors, Departments, and Appointments. Clearly identify entities, attributes, relationships, and cardinalities.20257mDATABASE MANAGEMENT SYSTEMConstruct an E-R diagram for a car insurance company that has a set of customers, each of whom owns one or more cars. Each car has associated with it zero to any number of recorded accidents..202114mDatabase Management SystemConsider: * 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))202510m
PreviousWhat are four main differences between file-processing system and a DBMS?NextWhat is the use of relational query language in DBMS? Use the example to explain tuple and domain relational calculus.
AI LearningWeb Platform
Coursify — Personal AI Course Generator
Struggling with a difficult subject or concept? Turn any engineering topic into a structured course with interactive lessons, quizzes, and research-backed explanations.