4007databse.db

BEGIN TRANSACTION;

CREATE TABLE ModuleTable ( mCode VARCHAR(7) PRIMARY KEY, Title VARCHAR(30));
INSERT INTO ModuleTable (mCode, Title) VALUES('5000', 'Introduction to Artifical Intelligence');
INSERT INTO ModuleTable (mCode, Title) VALUES('5001', 'Software Engineering');
INSERT INTO ModuleTable (mCode, Title) VALUES('5002', 'Theory Of Computation');
INSERT INTO ModuleTable (mCode, Title) VALUES('5003', 'Advancced Algorithims');

CREATE TABLE ClassTable (class VARCHAR(4) PRIMARY KEY);
INSERT INTO ClassTable (class) VALUES('YearONE'); 
INSERT INTO ClassTable (class) VALUES('YearTWO');
INSERT INTO ClassTable (class) VALUES('YearTHREE');

CREATE TABLE StudentTable (studentID INT(7) PRIMARY KEY, StudentName VARCHAR(30), originID INT(10) UNIQUE);
INSERT INTO StudentTable (studentID, StudentName, originID) VALUES(5245987, 'Bruce Willie Reed', 64629721);
INSERT INTO StudentTable (studentID, StudentName, originID) VALUES(7922126, 'Francis Hernandez Drake', 80959724);
INSERT INTO StudentTable (studentID, StudentName, originID) VALUES(2479195, 'Kenny Wu', 60248445);

CREATE TABLE LecturerTable (LecturerID INT(4) PRIMARY KEY, LecturerName VARCHAR(30));
INSERT INTO LecturerTable (LecturerID, LecturerName) VALUES(7894, 'Garrison Smith');
INSERT INTO LecturerTable (LecturerID, LecturerName) VALUES(6210, 'Jenna Frau');
INSERT INTO LecturerTable (LecturerID, LecturerName) VALUES(3791, 'Harley Sweede');
INSERT INTO LecturerTable (LecturerID, LecturerName) VALUES(9032, 'Ryan Winston');

CREATE TABLE Room(RoomNO VARCHAR(7) PRIMARY KEY);
INSERT INTO Room (RoomNO) VALUES('EC-15');
INSERT INTO Room (RoomNO) VALUES('EC-05');
INSERT INTO Room (RoomNO) VALUES('EC-13');

COMMIT TRANSACTION