--This is a sample script for tutorial 1

CONNECT TO SE4DB3;


CREATE TABLE Course(
	cid CHAR(2) NOT NULL,
	name CHAR(10),
	PRIMARY KEY (cid)
);

CREATE TABLE TA(
	tid CHAR(2) NOT NULL,
	name CHAR(10),
	cid CHAR(2) NOT NULL,
	PRIMARY KEY (tid),
	FOREIGN KEY (cid) REFERENCES COURSE
);


--Populates Course table

INSERT INTO Course VALUES ('c1', 'Database');
INSERT INTO Course VALUES ('c2', 'Math');


--Populate TA table

INSERT INTO TA VALUES ('t1', 'John','c1');
INSERT INTO TA VALUES ('t2', 'Smith', 'c1');
INSERT INTO TA VALUES ('t3', 'Mary', 'c2');

-- List all tables in database
LIST TABLES;

--List all records of TA table
SELECT * FROM TA;
SELECT * FROM Course;

TERMINATE;