Database
I have created an ERD using dbdiagram that can create visuals from text input, both text input and visuals are added below.
ERD

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 | |
EER
Using mysqldatabase I've created an EER with all the proper fields, relations and specifiers

SQL
From the previously made EER I can generate a mysql querry to create the database.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 | |
Step-by-Step Guide for Using the SQL Script
-
Clone the Repository: Begin by cloning the GitLab project repository to your local machine.
1git clone git@gitlab.fdmci.hva.nl:IoT/2024-2025-semester-1/individual-project/zuuliiyiizoo76.git -
Access the SQL Script: Navigate to the SQL script file in the project directory.
1cd zuuliiyiizoo7/web/php/ -
Database Creation: Open your MySQL client, then run the SQL script to set up the database.
1SOURCE smart_time_registration.sql; -
Verify Database Setup: Check that all tables are created successfully by listing the tables in the
smart_time_registrationdatabase:1 2
USE smart_time_registration; SHOW TABLES;
Accessing the SQL Script
You can find the SQL script in the GitLab project repository at the following link: