Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I tried running the code included but got an error that the table doesn't exist. How do I fix it? Set up RI between the

 I tried running the code included but got an error that the table doesn't exist. How do I fix it?


Set up RI between the sec0819_departmentstable and the sec0819_employeestable. Handle updates using the cascade rule. Then show the effect of this rule by changing the shipping department code in the sec0819_departments table from SHP to ABC.

MY CODE:

select s.Student_ID, s.First_Name, s.Last_Name, s.Major, c.Course_Number, c.Title from Enrollment e join Student s on e.Student_ID = s.Student_ID join Course c on e.Course_No = c.Course_Number where e.Grade = 'A';

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

Essentials Of Services Marketing

Authors: Jochen Wirtz

4th Edition

1292425199, 9781292425191

More Books

Students also viewed these Databases questions

Question

Describe Hobbess beliefs about human nature.

Answered: 1 week ago

Question

relatively high socioeconomic development

Answered: 1 week ago