UML 2 pour les bases de données
236
© Éditions Eyrolles
Tableau 3.30 Classe-association un-à-plusieurs SQL3
Schéma logique
Script SQL3 (Oracle)
Departement[codept,budget]
Achat[refDept, refLog, refServ,
datechat, dateinst]
Logiciel[nomlogi, prix]
Serveur[nserv, typeserv]
CREATE TYPE logiciel_type AS OBJECT
(nomlogi CHAR(20), prix NUMBER)
CREATE TYPE departement_type AS OBJECT
(codept CHAR(6), budget NUMBER)
CREATE TYPE serveur_type AS OBJECT
(nserv NUMBER, typeserv CHAR(20))
refServ REF serveur_type,
CREATE TABLE Departement
OF departement_type
(CONSTRAINT pk_dept PRIMARY KEY(codept))
CREATE TABLE Serveur OF serveur_type
(CONSTRAINT pk_serveur PRIMARY KEY(nserv))
CREATE TABLE Logiciel OF logiciel_type
(CONSTRAINT pk_log PRIMARY KEY(nomlogi))
CREATE TYPE achat_type AS OBJECT
(refDept REF departement_type,
refLog REF logiciel_type,
dateach DATE, dateinst DATE)
CREATE TABLE Achat OF achat_type
(CONSTRAINT nn_refDept CHECK
(refDept IS NOT NULL),
CONSTRAINT fk_refDept
refDept REFERENCES Departement
CONSTRAINT nn_refLog CHECK
(refLog IS NOT NULL),
CONSTRAINT fk_refLog
refLog REFERENCES Logiciel,
CONSTRAINT nn_refServ CHECK
(refServ IS NOT NULL),
CONSTRAINT fk_refServ
refServ REFERENCES Serveur)