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

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

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)