Question: I NEED HELP WITH THIS PLEASE!! COSC 1336 Database Lab Test Objective: Create SQL Statement and Show Resulting Tables (Each Problem is worth 10 points
I NEED HELP WITH THIS PLEASE!! 
COSC 1336 Database Lab Test Objective: Create SQL Statement and Show Resulting Tables (Each Problem is worth 10 points SQL (5 points) & Results (5 points) Figure 3 - Tables COURSES-Fall2014 TAUGHT-BY C-No. Inst CIT1341 Adams COURSES-Spring2015 C-No CIT1341 Intro to Networki CIT1345 Intro to CIT1355 Intro to CIT2301 Adv CIT2345 Adv Networki Course-Name Credit C-No CIT1341 Intro to CIT 1375 Intro Game CIT2301 Course-Name Credit CIT1355 Donner CIT1375 CIT2301 Brown CIT2325 Donner CIT2345 Adams Problem 1: Insert 3 credit course CIT2325 Adv Security into COURSES-Spring2015 Problem 2: Delete CIT2301 in COURSES-Fall2014. Problem 3: Update Intro to Programming to 4 Credits in COURSES-Fall2014 and COURSES-Spring2015 Problem 4: Select all 4 credit courses in COURSES-Fall2014 Problem 5: Project C-No. and Course-Name from COURSES-Spring2015 Problem 6: Join COURSES-Fall2014 with TAUGHT-By based on C-No Problem 7: Union Tables COURSES-Spring2015 and COURSES-Fall2014 Problem 8: Intersection Tables COURSES-Spring2014 and COURSES-Fall2014 Problem 9: Difference Tables COURSES- Fall2014 and COURSES-Spring2015 Problem 10: Union and Join Tables COURSES-Fall2014, COURSES- Spring2015 and TAUGHT-By
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
