Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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 CID

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

=+What do they (audience members) currently think?

Answered: 1 week ago

Question

2. What type of team would you recommend?

Answered: 1 week ago