Question: subject: data base management system please send it in 30 minutes urgent please send it fast Consider two tables in a relational database with columns

subject: data base management system please send it in 30 minutes urgent please send it fast
Consider two tables in a relational database with columns and rows as follows: [10 Marks] Roll_no is the primary key of the Student table, Dept_id is the primary key of the Department table and Student. Dept_id is a forcign key referring to Department. Dept_id. What will happen if we try to do following operation. (1.) Change the Dept id to 3 of student having roll no 1. Change the Dept_id to 4 for the department A. A new students information (5,LMN,3) is added. C. A new department is introduced (S,Z). A new student (6,PQR,7) is added. Write the updated Student and Department table after the above operations
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
