Changes between Initial Version and Version 1 of Normalization

Timestamp:

09/12/25 19:16:19 (7 weeks ago)

Author:

221028

Comment:

--

Normalization

@@ +1 @@
+
+== Нормализација на базата и функционални карактеристики
+
+* Субтипови за корисник — јасна поделба на улоги:
+
+
+{{{
+User(user_id, user_name, user_surname, email, password, role)
+
+}}}
+
+
+{{{
+student(student_id → User.user_id, teacher_id → User.user_id)
+}}}
+
+
+
+{{{
+teacher(teacher_id → User.user_id)
+}}}
+
+
+* Домен-табели
+
+{{{
+elements(element_id, symbol, element_name, atomic_number, atomic_weight, melting_point, boiling_point, hazard_type, description_element, teacher_id→User)
+}}}
+
+
+
+{{{
+labequipment(equipment_id, equipment_name, type, description, safety_info, teacher_id→User)
+}}}
+
+
+
+{{{
+reaction(reaction_id, teacher_id→User, element1_id→elements, element2_id→elements, product, conditions)
+
+}}}
+
+
+{{{
+experiment(experiment_id, teacher_id→User, reaction_id→reaction, result, safety_warning, time_stamp)
+}}}
+
+
+* N:M релации
+
+{{{
+experimentlabequipment(experiment_id→experiment, equipment_id→labequipment)
+
+}}}
+
+
+{{{
+userparticipatesinexperiment(user_id→User, experiment_id→experiment[, participation_timestamp])
+}}}
+
+
+* Tracking-табели (активности/прегледи):
+
+
+{{{
+userviewselement(user_id→User, element_id→elements)
+}}}
+
+
+
+{{{
+userviewslabequipment(user_id→User, equipment_id→labequipment)
+}}}
+