Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE OUVRAGE
- (
- Numero INT NOT NULL,
- Titre VARCHAR(20),
- Auteur VARCHAR(30),
- Editeur VARCHAR(10),
- Prix INT,
- Codetheme VARCHAR(2),
- Constraint ouvrage_id PRIMARY KEY(Numero),
- Constraint codetheme_id FOREIGN KEY(Codetheme) REFERENCES THEME
- );
- CREATE TABLE THEME
- (
- Code VARCHAR(2),
- Libelle VARCHAR(20),
- Constraint code_id PRIMARY KEY(Code)
- );
- ALTER TABLE OUVRAGE
- MODIFY Editeur VARCHAR(20);
- ALTER TABLE OUVRAGE
- ADD Date_achat DATE;
- ALTER TABLE OUVRAGE
- DROP CONSTRAINT codetheme_id;
- ALTER TABLE OUVRAGE
- ADD CONSTRAINT codetheme_id FOREIGN KEY (Codetheme) REFERENCES THEME ON DELETE CASCADE;
- INSERT INTO THEME
- VALUES ('BD','Base de donnees');
- INSERT INTO THEME
- VALUES ('LE','Litterature');
- INSERT INTO THEME
- VALUES ('ME','Metho');
- INSERT INTO OUVRAGE --(Numero, Titre, Auteur, Editeur, Prix, Codetheme, Date_achat)
- VALUES(1, 'SQL', 'Date', 'InterEditions', 29.90, 'BD', DATE'2008-09-09');
- INSERT INTO OUVRAGE
- VALUES(10, 'Merise', 'Laroche', 'Dunod', 35.50, 'LE', DATE'2009-08-25');
- INSERT INTO OUVRAGE
- VALUES(15, 'Le rouge et le noir', 'Stendhal', 'Folio', 5.50, 'ME', DATE'2010-03-31');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement