Create a Program to Alter Database Tables in SQL Assignment Solution

Instructions

Objective

Write a SQL assignment program to alter database tables in SQL language.

Requirements and Specifications

CE3.1a Change Column Name, Test Name Change, Generate Summaries:

CE3.1b - Insert Rows, Generate Summaries:

Source Code

-- Part 2 -- Q1 SELECT C.course_name FROM course_table C, registration_table R, student_table S WHERE C.course_id = R.course_id AND R.student_id = S.student_id AND S.student_name = 'Smith'; -- Q2 SELECT F.faculty_name FROM faculty_table F INNER JOIN course_table C ON C.instructor_id = F.faculty_id INNER JOIN registration_table R ON C.course_id = R.course_id INNER JOIN student_table S ON R.student_id = S.student_id WHERE S.student_name = 'Baker' -- Q3 SELECT S.student_id, S.student_name, SUM(C.num_credits) FROM student_table S, registration_table R, course_table C WHERE R.student_id = S.student_id AND C.course_id = R.course_id GROUP BY S.student_name, S.student_id; -- Q4 SELECT F.faculty_name FROM faculty_table F, course_table C, registration_table R, student_table S WHERE F.faculty_id = C.instructor_id AND C.course_id = R.course_id AND R.student_id = S.student_id AND C.course_id = 'INFO 364' AND R.grade = 4;