Mid-Term Exam, Date: 16-02-25 (DBMS)

 Gono Bishwabidyalay

Department of Computer Science & Engineering

Mid-term Exam, October-2024

Course Code: CSE-3501, Course Tittle: Database Management System

Marks: 10                                                Time: 30 minutes

1)      Consider the relational database:                                                                        1 x 5 = 5

 Students (Roll, SName, SAddress, SContact, SFee)       

           Teachers (TID, TName, TSalary, TAddress)

           Teaches (Roll, TID)

            Write the relational algebra for the following:

1. Find the Roll of all students who are taught by teacher "Raman".
2. Delete all students who are from Biratnagar.
3. Increase the fee of students who are from Kathmandu by 2%.
4. Find the name of teacher who lives in Kathmandu and get salary greater than Rs. 100000.
5. Change the name of student to Sushila whose roll number is 10.

     

       2) Difference between Primary key and Foreign key.                                                              5