uni_TimeTable.sql

--
-- File generated with SQLiteStudio v3.1.0 on Fri Aug 23 04:08:05 2019
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: Room
CREATE TABLE Room ("Room code" VARCHAR (6) PRIMARY KEY);
INSERT INTO Room ("Room code") VALUES ('ECG-24');
INSERT INTO Room ("Room code") VALUES ('ECG-12');
INSERT INTO Room ("Room code") VALUES ('ECG-15');

-- Table: Modules
CREATE TABLE Modules (Code VARCHAR (7) PRIMARY KEY, name VARCHAR (30));
INSERT INTO Modules (Code, name) VALUES ('4000', 'Programming and Algorithms');
INSERT INTO Modules (Code, name) VALUES ('4006', 'Computer Science Activity Led Learning');
INSERT INTO Modules (Code, name) VALUES ('4005', 'Database Systems');

-- Table: Students
CREATE TABLE Students (ID INT (7) PRIMARY KEY, name VARCHAR (30), number INT (10) UNIQUE);
INSERT INTO Students (ID, name, number) VALUES (9976521, 'Oluwa Tosin Favour Oluyemi', 554632045);
INSERT INTO Students (ID, name, number) VALUES (8965315, 'Ahmed Sagir Koki', 778983860);
INSERT INTO Students (ID, name, number) VALUES (2664127, 'Justice Tudor Kpakol', 546978213);

-- Table: Module_Class
CREATE TABLE Module_Class (module REFERENCES Modules (Code), class REFERENCES Class (Class_number), room REFERENCES Room ("Room code"));
INSERT INTO Module_Class (module, class, room) VALUES (4000, 'Year1', 'ECG-12');
INSERT INTO Module_Class (module, class, room) VALUES (4005, 'Year1', 'ECG-24');
INSERT INTO Module_Class (module, class, room) VALUES (4006, 'Year1', 'ECG-15');

-- Table: Lecturer_module
CREATE TABLE Lecturer_module (lecturer REFERENCES Lecturers (Lect_ID), module REFERENCES Modules (Code));
INSERT INTO Lecturer_module (lecturer, module) VALUES (123456, 4000);
INSERT INTO Lecturer_module (lecturer, module) VALUES (654321, 4006);
INSERT INTO Lecturer_module (lecturer, module) VALUES (789456, 4005);

-- Table: Class
CREATE TABLE Class (Class_number VARCHAR (4) PRIMARY KEY);
INSERT INTO Class (Class_number) VALUES ('Year1');
INSERT INTO Class (Class_number) VALUES ('Year2');
INSERT INTO Class (Class_number) VALUES ('Year3');

-- Table: Lecturers
CREATE TABLE Lecturers (Lect_ID INT (6) PRIMARY KEY, Name VARCHAR (30), number INT (10) UNIQUE);
INSERT INTO Lecturers (Lect_ID, Name, number) VALUES (123456, 'Mathew England', 9876543210);
INSERT INTO Lecturers (Lect_ID, Name, number) VALUES (789456, 'Diana Hintea', 456123789);
INSERT INTO Lecturers (Lect_ID, Name, number) VALUES (654321, 'Simon Billings', 1234567890);

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;