I am currently working on a research, uhmm, prolly will create an application out of it, the system is an "intern management system" . My question is how will you structure your database if you are in my shoes?
but before answering, take a look at this, this is what's on my mind
table : users
table : roles
table : *user_role*
- user_id reference users(user_id)
- role_id reference roles(role_id)
table : status
table : *user_status*
user_id *reference* users(user_id)
status *reference* status(status_id)
the above is the current structure of my database, any suggestion on the above?
how about if i am going to add the
users a field of
if he is on college of engineering, or in college of business ad . . and so on and so forth,
the college of engineering has many courses within it, how do i handle that kind of situation, should i just create a table called
college_courses and lastly a table
called user_college_course? what do you think?