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)); |
Partager