Question: Consider the relations Student, Course, Faculty, and Enrollment as described in Problem 2. Write SQL statements for each of the following queries: 1. Insert the

 Consider the relations Student, Course, Faculty, and Enrollment as described in

Consider the relations Student, Course, Faculty, and Enrollment as described in Problem 2. Write SQL statements for each of the following queries: 1. Insert the following new tuple in Student: James with FSUID as james123; 2. Remove all professors from Faculty, who are not teaching any course 3. Update the name of the student with FSUID as joey7, to Joe; 4. Create a view Busy Professors, containing the names of all professors for whom the number of students they teach across their courses is greater than 100 (Note if a student is enrolled in two different courses of the same professor, we count the student only once.)

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!