Changes between Version 2 and Version 3 of RelationalDesign

Timestamp:

02/06/25 16:27:23 (2 weeks ago)

Author:

221028

Comment:

--

RelationalDesign

@@ -8 +8 @@
 - останати атрибути      - без ознака
 === Табели
-- USER (**__user_id__**, **user_name**, **user_surename**, **username**, **password**, **role**)
-- LABEQUIPMENT (__**equipment_id__**, **equipment_name**, type, description, safety_info)
-- ELEMENT (__**element_id__**, **symbol**, **element_name**,**atomic_number**, **atomic_weight**, melting_point,boiling_point,hazzard_type,description_element)
-- REACTION (__**reaction_id__**, **element1_id*** (ELEMENT), **element2_id*** (ELEMENT), product,conditions)
-- EXPERIMENT(__**experiment_id**__, **user_id*** (USER), **reaction_id*** (REACTON),result,time_stamp,safety_warning)
+- USER (**__user_id__**, **user_name**, **user_surename**, **email**, **password**, **role**)
+- STUDENT (**__student_id__*** (USER), **teacher_id*** (TEACHER))
+- TEACHER (**__teacher_id__*** (USER))
+- LABEQUIPMENT (__**equipment_id__**, **equipment_name**, type, description, safety_info, **teacher_id*** (TEACHER) )
+- ELEMENT (__**element_id__**, **symbol**, **element_name**,**atomic_number**, **atomic_weight**, melting_point,boiling_point,hazzard_type,description_element, **teacher_id*** (TEACHER))
+- REACTION (__**reaction_id__**, **teacher_id*** (TEACHER) **element1_id*** (ELEMENT), **element2_id*** (ELEMENT), product,conditions)
+- EXPERIMENT(__**experiment_id**__, **teacher_id*** (TEACHER), **reaction_id*** (REACTON),result,time_stamp,safety_warning)
 - EXPERIMENTLABEQUIPMENT(**__experiment_id__*** (EXPERIMENT), **__equipment_id__*** (LABEQUIPMENT))
+- USERVIEWSELEMENT (**__user_id__*** (USER), **__element_id__*** (ELEMENT))
+- USERVIEWSLABEQUIPMENT (**__user_id__*** (USER), **___equipment_id__*** (LABEQUIPMENT))
+- USERVIEWSEXPERIMENT (**__user_id__*** (USER), **__experiment_id__*** (EXPERIMENT))
+- USERPARTICIPATESINEXPERIMENT (**__user_id__*** (USER), **__experiment_id__*** (EXPERIMENT))
 
 
@@ -20 +26 @@
 === DML скрипта за полнење на табелите со податоци
 [wiki:dmlScript.sql DML скрипта]
-=== Релациски дијаграм изваден од DBeaver
-[[Image(dijagramRelaciski.png)]]
+=== Релациски дијаграм
+[[Image(relaciskiD.png)]]