Here's the problem: I'm unable to resolve which table should have a column for graduation year, or if it should be a separate table altogether.
My understanding is that ONE user has ONE grad year, but MANY schools have MANY grad years. Also, ONE school has MANY students (users).
Knowing this, does it make sense to include a column for grad year under the Users table? Or would populating this grad year column under the users table create redundant data that would excessively increase the size of the DB?
Is it a better decision to make a separate table for graduation years which would look something like the following?
5. Grad Years
-- Grad year ID
-- Grad Year
Would this Grad Years table then be linked to the Users and Schools tables?
Or is there a better solution altogether?
I hope this all makes sense.....if not, write back and I'll try to clarify any questions you may about my questions.