Changes between Version 4 and Version 5 of RelationalDesign
- Timestamp:
- 12/04/22 21:24:36 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v4 v5 22 22 - //projection_rooms//(**__ID_room__**, **number_of_seats** ,**projection_room_number**, **ID_cinema*__**(Cinemas)) 23 23 - //categories//(**__ID_category__**, **name**, extra_amount) 24 - customer_rates_film(**__ID_customer*__**(Customer),**__ID_film&__**(Films),**rating**) 25 - cinema_plays_film(**__ID_cinema*__**(Cinemas),**__ID_film&__**(Films)) 26 - cinema_organizes_event(**__ID_cinema*__**(Cinemas),**__ID_Event&__**(Events)) 27 - projection_is_played_in_room(**__ID_projection*__**(Projections),**__ID_Room&__**(Projection_Rooms)) 28 24 29 25 30 … … 27 32 == DDL скрипта за бришење на табелите и креирање на табелите 28 33 29 '''[attachment:kreiranje.sql .sql]'''34 '''[attachment:kreiranje.sql]''' 30 35 31 36 == DML скрипта за полнење на табелите со податоци