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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!