Back to the 2024 paper
Similar questions
Database 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))202510mDatabase Management SystemWhat is the use of relational query language in DBMS? Use the example to explain tuple and domain relational calculus.20207mDatabase Management SystemA relational database developer refers to a record as (i) a criterion (ii) a relation (iii) a tuple (iv) an attribute20202mArtificial intelligenceWhat are not represented by using propositional logic? (i) Objects (ii) Relations (iii) Both objects and relations (iv) None of the above20202m