1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
CREATE TABLE Module
(
CodeUE CHAR(3) PRIMARY KEY,
LibelleUE VARCHAR(20) NOT NULL,
HC NUMBER(5) NOT NULL,
HTD NUMBER(5) NOT NULL,
HTP NUMBER(5) NOT NULL);
CREATE TABLE Enseignant
(
NumEns NUMBER(3) PRIMARY KEY,
NomEns VARCHAR(20) NOT NULL,
Grade VARCHAR(20) REFERENCES Grades(Grade),
ServiceEffectif NUMBER(2) DEFAULT 0);
CREATE TABLE Grades
(
Grade VARCHAR(20) PRIMARY KEY,
ServiceMin NUMBER(3) NOT NULL,
ServiceMax NUMBER(3));
CREATE TABLE Service
(
NUmEns NUMBER REFERENCES Enseignant(NumEns),
CodeUE CHAR REFERENCES Module(CodeUE),
HCEns NUMBER(5) NOT NULL,
HTDEns NUMBER(5) NOT NULL,
HTPEns NUMBER(5) NOT NULL,
PRIMARY KEY(NumEns,HCEns)); |
