Data Model & ERD - Githubissues

vdeoli01 / a-level-guidance-app

A-Level-Guidance-App aids GCSE students in the UK with A-level choices. Using an algorithm, it recommends subjects based on user input. Additionally, it offers mentorship options. A tool to simplify the pivotal A-level selection process.

0 stars 0 forks source link

Data Model & ERD #12

Closed vdeoli01 closed 1 year ago

vdeoli01 commented 1 year ago

Simple Data Model

vdeoli01 commented 1 year ago

ERD Diagram

vdeoli01 commented 1 year ago

Changes to make

[x] Delete Slot.end_time as decided all slots will be 30 minutes
[x] Add name to slot table to show advisors name that will be hosting the slot

vdeoli01 commented 1 year ago

;

vdeoli01 commented 1 year ago

Made a few edits to the ERD to make things easier The tables were originally very normalised meaning it would take less storage as it reduced data duplication This was becoming complex in the implementation stage though and queries were more complex so opted to "denormalise" and make it simpler The new table is below: