Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Cle prim. Place = NUMERO_PLACE
- Cle prim. Seance = NUMERO_SEANCE
- Cle prim. Reservation = NUMERO_SEANCE, NUMERO_PLACE
- 6: P = clef primaire
- R = clef étrangère
- 13:
- Solution : describe & select CONSTRAINT_TYPE , CONSTRAINT_NAME , SEARCH_CONDITION , COLUMN_NAME
- from ALL_CONSTRAINTS
- natural join ALL_CONS_COLUMNS
- where OWNER = 'ADMIN' and TABLE_NAME in ('PLACE', 'RESERVATION' , 'SEANCDE')
- order by CONSTRAINT_TYPE , CONSTRAINT_NAME ;
- PLACE (NUMERO_PLACE , CATEGORIE_DE_LA_PLACE)
- Clef Primaire : NUMERO_PLACE
- Clef Etrangère : CATEGORIE_DE_LA_PLACE
- Non Nul : CATEGORIE_DE_LA_PLACE
- SEANCE (NUMERO_SEANCE, NUMERO_FILM, CATEGORIE_DE_LA_SEANCE, DATE_DE_LA_SEANCE, HORAIRE)
- Clef Primaire : NUMERO_PLACE
- Clefs Etrangères : NUMERO_FILM, CATEGORIE_DE_LA_SEANCE
- Non Nul : CATEGORIE_DE_LA_SEANCE
- Horaire in (14,16,18,20,22)
- RESERVATION (NUMERO_SEANCE, NUMERO_PLACE, NOM_SPECTATEUR)
- Clef Primaire : NUMERO_SEANCE, NUMERO_PLACE
- Clefs Etrangeres : NUMERO_SEANCE, NUMERO_PLACE
- 14: une vue peut concerner plusieurs tables, des jointures etc. elle est le résultat d'une requête.
- 15 : SELECT NUMERO_SEANCE, NUMERO_PLACE, NOM_SPECTATEUR
- FROM RESERVATION
- NATURAL JOIN PLACE
- WHERE CATEGORIE_DE_LA_PLACE = 'A'
- 18: SELECT *
- FROM CATEGORIE_RESERVATION_A
- 19: lol
- 20: SELECT SEANCE.NUMERO_SEANCE , COUNT(NOM_SPECTATEUR)
- FROM SEANCE
- INNER JOIN RESERVATION_CATEGORIE_A ON RESERVATION_CATEGORIE_A.NUMERO_SEANCE = SEANCE.NUMERO_SEANCE
- GROUP BY SEANCE.NUMERO_SEANCE;
Add Comment
Please, Sign In to add comment