Changes between Version 1 and Version 2 of RelationalDesign

Timestamp:

12/04/22 21:07:00 (2 years ago)

Author:

201094

Comment:

--

RelationalDesign

@@ -4 +4 @@
 
  - Примарните клучеви се означени со bold и underline
- - Надворешните клучеви се означени со *,^,%,&
+ - Надворешните клучеви се означени со *,#,%,&
  - Задолжителни атрибути, односно not null со bold 
 
@@ -10 +10 @@
 
  - //users// (**__ID_user__**, **username**, **password**, **first_name**, **last_name**,  address, contact_number, date_created)
- - //workers//(**__ID_worker*__**(users), **position**, **work_hours_from**,**work_hours_to**, **ID_cinema^**(cinemas))
+ - //workers//(**__ID_worker*__**(users), **position**, **work_hours_from**,**work_hours_to**, **ID_cinema#**(cinemas))
  - //customers//(**__ID_customer*__**(users),points) 
  - //salaries//(**__ID_salary__**, **sum**, **date_from**, date_to, **ID_worker*__**(Workers))
@@ -16 +16 @@
  - //cinemas//(**__ID_Cinema__**, **name**, **location**)
  - //events//(**__ID_event__**, **theme**, **duration**, **repeating**, **start_dates**)
- - //projections//(**__ID_projection__**, **date_time_start**, **type_of_technology**,**date_time_end**, **ID_film*__*(Films), ID_discount^(Discounts), ID_event%(Events))
- - //tickets//(**__ID_ticket__**, **price** , **ID_customer*__**(Customer), **ID_projection&**(Projections), ID_discount^(Discounts),**ID_seat%**(Seats))
+ - //projections//(**__ID_projection__**, **date_time_start**, **type_of_technology**,**date_time_end**, **ID_film*__*(Films), ID_discount#(Discounts), ID_event%(Events))
+ - //tickets//(**__ID_ticket__**, **price** , **ID_customer*__**(Customer), **ID_projection&**(Projections), ID_discount#(Discounts),**ID_seat%**(Seats))
  - //discounts//(**__ID_discount__**, **validity**, **code**, **type**, **percent**)
  - //seats//(**__ID_seat__**, **seat_number**, **ID_room*__**(Projection_Rooms) ,**ID_category&**(Categories))