Warning: Undefined array key "REMOTE_USER" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 36
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 219
Warning: Undefined array key "date" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 226
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 228
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 292
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 397
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 219
Warning: Undefined array key "date" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 226
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 228
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 292
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 397
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 219
Warning: Undefined array key "date" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 226
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 228
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 292
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 397
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 219
Warning: Undefined array key "date" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 226
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 228
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 292
Warning: Undefined array key "media" in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/feed.php on line 397 HEC 4 ALL 3:bases_de_donnees
https://fritscher.ch/hec/
Tue, 12 May 2026 08:46:18 +0000FeedCreator 1.8https://fritscher.ch/hec/lib/tpl/arctic/images/favicon.icoHEC 4 ALL
https://fritscher.ch/hec/
Modélisation et réalisation d'une BD pour un site sur le cinéma
https://fritscher.ch/hec/3/bases_de_donnees/cinema?rev=1203260080&do=diff
Modélisation et réalisation d'une BD pour un site sur le cinéma
Rapports
Fichier DB-Main 8:
Description du projet: [Rapport 1]
Entité association [Rapport 2]
Relationnel: [Rapport 3] [Graphiques des DF]
SQL: SELECT, CHECK, Triggers: [Rapport 4]
Code relationnel
-- *********************************************
-- * Projet Base de donnée: Groupe Cinéma
-- *********************************************
-- Tables Section
-- _____________
create table Bonus (
ID_Film integer not nul…anonymous@undisclosed.example.com (Anonymous)3:bases_de_donneesSun, 17 Feb 2008 15:54:40 +0000TP
https://fritscher.ch/hec/3/bases_de_donnees/tp?rev=1162926688&do=diff
TP
TP 1
*
*anonymous@undisclosed.example.com (Anonymous)3:bases_de_donneesTue, 07 Nov 2006 20:11:28 +0000TP3
https://fritscher.ch/hec/3/bases_de_donnees/tp3?rev=1165265703&do=diff
TP3
1:
SELECT DateNaissance, Adresse
FROM employe
WHERE Nom='Rochat' AND Prenom='Juliette'
2:
SELECT Nom, Adresse
FROM Employe NATURAL JOIN Departement
WHERE NomD = 'Recherche'
3:
SELECT E1.Nom, E1.Prenom
FROM Employe E1, Employe E2
WHERE E1.superieur = E2.noavs AND E2.nom = 'Rochat' AND E2.prenom = 'Juliette'anonymous@undisclosed.example.com (Anonymous)3:bases_de_donneesMon, 04 Dec 2006 21:55:03 +0000TP4
https://fritscher.ch/hec/3/bases_de_donnees/tp4?rev=1165938678&do=diff
TP4
1b
CREATE OR REPLACE TRIGGER TR1b
AFTER DELETE ON Artiste
FOR EACH ROW
BEGIN
UPDATE Album SET Artiste = NULL WHERE Artiste = :old.nom;
END;
1c
CREATE OR REPLACE TRIGGER TR1c
AFTER DELETE ON artiste
FOR EACH ROW
BEGIN
DELETE album WHERE artiste = :old.nom;
END;
CREATE OR REPLACE TRIGGER T1c2
AFTER DELETE ON album
FOR EACH ROW
BEGIN
DELETE chanson WHERE album = :old.titre;
END;anonymous@undisclosed.example.com (Anonymous)3:bases_de_donneesTue, 12 Dec 2006 16:51:18 +0000