Java Midyear Project:
Research Center Management System

Java program with JavaFX GUI and MySQL database.

Screenshots

Class Diagram

Relational Model

• personnel (personnel_id, full_name, role, login, password)
• researcher (#researcher_id, full_name, #experiment_id)
• field (field_designation)
• specialty (#researcher_id, #field_designation)
• lab (lab_id, location)
• experiment (experiment_id, #researcher_id, state, code_name, description, #lab_id)
• material_type (material_designation, stocked_quantity)
• equipment_type (equipment_designation)
• equipment (equipment_id, #equipment_designation, #experiment_id)
• request (request_id, state, type, #experiment_id, #field_designation, #material_designation, #equipment_designation, quantity, details)