TnkLKZDU

1CREATE TABLE IF NOT EXISTS Course (
2    course_id INTEGER primary key,
3	title VARCHAR(100), year INTEGER,
4	semester INTEGER, url VARCHAR(200), 
5    credits INTEGER);
6
7CREATE TABLE IF NOT EXISTS Lecturer (
8    lecturer_id INTEGER primary key,
9	name VARCHAR(100), email VARCHAR(200));
10
11CREATE TABLE IF NOT EXISTS OptionalPackage(
12	package_id INTEGER primary key,
13    year INTEGER, semester INTEGER);
14
15
16CREATE TABLE IF NOT EXISTS Lecturer_course(
17	    lecturer_id INTEGER NOT NULL,
18	    course_id INTEGER NOT NULL,
19        FOREIGN KEY (lecturer_id) REFERENCES Lecturer (lecturer_id),
20        FOREIGN KEY (course_id) REFERENCES Course (course_id),
21        PRIMARY KEY (lecturer_id, course_id));
22
23        
24CREATE TABLE IF NOT EXISTS OptionalPackage_Course(
25	    package_id INTEGER NOT NULL,
26	    course_id INTEGER NOT NULL,
27        FOREIGN KEY (package_id) REFERENCES OptionalPackage (package_id),
28        FOREIGN KEY (course_id) REFERENCES Course (course_id),
29        PRIMARY KEY (package_id, course_id));