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'

4:

SELECT Nomp FROM Projet P NATURAL JOIN Travaille T LEFT JOIN Employe E ON T.noavs = E.noavs
WHERE (E.nom = 'Muller' AND E.prenom = 'Jean') OR (E.nom = 'Grandjean' AND E.prenom = 'Annie')

5:

6:

7: