CSCI 250 - Table Example (SQL Statements)

CREATE TABLE NameTable (StudentID INT, LastName CHAR(20), FirstName CHAR(15))
INSERT INTO NameTable VALUES (123, 'Doe', 'John')
INSERT INTO NameTable VALUES (124, 'Doe', 'Jane')
INSERT INTO NameTable VALUES (125, 'Jones', 'John')
CREATE TABLE CourseTable (StudentID INT, Course CHAR(8))
INSERT INTO CourseTable VALUES (123, 'CSCI 250')
INSERT INTO CourseTable VALUES (123, 'MATH 240')
INSERT INTO CourseTable VALUES (123, 'MATH 130')
INSERT INTO CourseTable VALUES (124, 'CSCI 150')
INSERT INTO CourseTable VALUES (124, 'HIST 110')