· 7 years ago · Feb 20, 2019, 12:38 AM
1CREATE TABLE IF NOT EXISTS Section(
2 cno VARCHAR(20) NOT NULL,
3 sectno VARCHAR(20) NOT NULL,
4 pID VARCHAR(20) NOT NULL,
5
6 PRIMARY KEY(cno, sectno),
7 FOREIGN KEY (pID) REFERENCES Prof(pID),
8 FOREIGN KEY (cno) REFERENCES Cours(cno) ON DELETE CASCADE
9);
10
11CREATE TABLE IF NOT EXISTS Inscription(
12 sid VARCHAR(20) NOT NULL,
13 cno VARCHAR(20) NOT NULL,
14 pID VARCHAR(20) NOT NULL,
15 note INT CHECK (note >= 0 && note <= 100),
16
17 PRIMARY KEY(sid, cno, sectno),
18 FOREIGN KEY (pID) REFERENCES Prof(pID),
19 FOREIGN KEY (cno) REFERENCES Cours(cno),
20);