Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each of the following questions, show the contents of the database (i,e, re-draw the tables showing the data) after performing the given SQL statements.
For each of the following questions, show the contents of the database (i,e, re-draw the tables showing the data) after performing the given SQL statements. Assume each SQL statement is performed on the original database instance without considering the effect of the previous statements.
1) delete from Student where sid = 1;
2)(5 Points) update Course set cid = 3 where cid = 2;
3) (5 Points) update Register set sid = 3 where sid = 4;
Consider the following database instance Table name: Student Primary key: SID SID SNAME oe Susan Ed Table name: Course Primary key: CID CNAME Accounting CIS CID Table name: Register Primary key: SID CIID Foreign key: SID references Student(SID) on delete cascade Foreign key: CID references Course(CID) on update cascade SID CIDStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started