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

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


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