Database structures

nickn · 2024-07-17T19:05:18.629Z

I am struggling to find the best way to manage some data. I have a website where past pupils register for scholls they went to. They can do this for multiple schools. When they register they must say which year they gratuated. Should it be stored under the User or School Database (information about each school) or a nee database? Consider that a user could be a graduate of more than one school on my system. I need this data to know who to invite to reunions. Please try tell me which databases yiu would refer to others too. Like i record the amount of graduates by making sure there is a Database of Graduates under the School database Please let me know your thoughts. Thank you

Zeroic · 2024-07-17T19:11:08.043Z

Hi! So you ideally have these tables in your DB

School (with its name, location etc)
User (name, email etc)

Add a Graduation table (School field, User field, Year of graduation as a text/date)

This way it links the 2 together (the User and its School) and passes additional information about its relationship (the year of graduation)

Let me know if this works for your use-case

system · 2024-09-25T19:05:26.651Z

This topic was automatically closed after 70 days. New replies are no longer allowed.