Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Provide a mySql code Lets suppose that student Amy requests to be removed from the database. What would be the expected result from running this

Provide a mySql code

Lets suppose that student Amy requests to be removed from the database. What would be the expected result from running this SQL query:

DELETE FROM Student WHERE sId=123;

If the goal was to have all associated applications removed from the database when a student is deleted, which referential triggered action should have been declared for the ON DELETE foreign key relationship between Apply.sID and Student.Id?

image text in transcribed

decision major EE CS: EE- CS: CS. biology bioengineering | cs. EE Apply SID Name- 123: Cornell 123+ OSU: 123- OSU- 123 U of O- 123- MIT- 234 U of O 345. Cornell 345 Cornell 345 Cornell 345 MIT 543 MIT 678. Cornell 678- Cornell- 678. OSU. 765 OSU 876. MIT 876- MIT- 876. OSU. 987 OSU: 987. U of O. bioengineering CS history psychology history history biology marine biology CS. CSH CS. Student SIDsName 1232 Amy. 234 Bobo 345. Craig 456 Doris. Craig 567 Edward 654. Amy- 6780 Faye 7652 Jaye 789. Gary 876 Irene 9872 Helen- GPA 3.90- 3.60- 3.50. 3.90 3.40- 2.90- 3.90- 3.80- 2.90 3.40 3.90 3.70- sizeHS- 1000- 1500- 500 1000- 2000- 2000- 1000- 200- 1500- 800 400- 800- Minimum GPA Name- major OSU. CS. OSU- EE OSU- history U of O CS- U of O. biology Cornell bioengineering Cornelle CS: Cornello EE Cornell history Cornello psychology MIT biology MIT bioengineering MIT CSH MIT marine biology min GPA 3.75- 3.52 2.8 3.62 3.75 3.8 3.4 3.60 3.6- la 2.8 College Nmae Cornell MIT- OSU- U of O. State. NY MA- OR enrollment 21000- 10000- 28000- 25000 3.5+ 3.5. 3.9. 3.5. OR

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

Data Management Databases And Organizations

Authors: Watson Watson

5th Edition

0471715360, 978-0471715368

More Books

Students also viewed these Databases questions