Create SQL Statement and Show Resulting Tables TABLES COURSES- Spring2015 C- No.
ID: 3687739 • Letter: C
Question
Create SQL Statement and Show Resulting Tables
TABLES
COURSES- Spring2015
C- No.
COURSE- Name
Credit
CIT1341
Intro to Networking
3
CIT1375
Intro Game Program
4
CIT2301
Adv Programming
4
TAUGHT-BY
C- No.
Instructors
CIT1341
Adams
CIT1345
Brown
CIT1355
Donner
CIT1375
Gambling
CIT2301
Brown
CIT2325
Donner
CIT2345
Adams
COURSES -FALL2014
C- No.
COURSE- Name
Credit
CIT1341
Intro to Networking
3
CIT1345
Intro to Programming
3
CIT1355
Intro to Security
4
CIT2301
Adv Programming
4
CIT2345
Adv Networking
5
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
C- No.
COURSE- Name
Credit
CIT1341
Intro to Networking
3
CIT1375
Intro Game Program
4
CIT2301
Adv Programming
4
Explanation / Answer
Problem-1:
INSERT INTO COURSES- Spring2015 (C- No., COURSE- Name, Credit)
VALUES ('CIT2325 ', 'Adv Security', '3');
Problem-2:
DELETE FROM COURSES-Fall2014
WHERE C- No='CIT2301 ';
Problem-3
UPDATE COURSES- Spring2015
SET COURSE- Name='Intro to Programming'
WHERE Credit='4';
UPDATE COURSES-Fall2014
SET COURSE- Name='Intro to Programming'
WHERE Credit='4';