Question: 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

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!