== Нормализација на базата и функционални карактеристики

* Субтипови за корисник — јасна поделба на улоги:


{{{
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)
}}}

|| Табела                       || PK                              || Важни FK                                || НФ статус                         ||
|| User                        || user_id                          || —                                       || 3NF / BCNF (формално по user_id)  ||
|| student                     || student_id                       || teacher_id → User                       || 3NF / BCNF                        ||
|| teacher                     || teacher_id                       || —                                       || 3NF / BCNF                        ||
|| elements                    || element_id                       || teacher_id → User                       || 3NF / BCNF                        ||
|| labequipment                || equipment_id                     || teacher_id → User                       || 3NF / BCNF                        ||
|| reaction                    || reaction_id                      || teacher_id, element1_id, element2_id    || 3NF / BCNF                        ||
|| experiment                  || experiment_id                    || teacher_id, reaction_id                  || 3NF / BCNF                        ||
|| experimentlabequipment      || (experiment_id, equipment_id)    || експеримент / опрема                     || 3NF / BCNF                        ||
|| userparticipatesinexperiment|| (user_id, experiment_id)         || корисник / експеримент                   || 3NF / BCNF                        ||
|| userviewselement            || (user_id, element_id)            || корисник / елемент                       || 3NF / BCNF                        ||
|| userviewslabequipment       || (user_id, equipment_id)          || корисник / опрема                        || 3NF / BCNF                        ||