advice with schedule table structure.
Posted: Mon Jul 30, 2007 4:46 pm
Hello, I am very new at MySQL and PHP, I'm not quite all the way finished my first book and I'm kinda trying to jump right in.
I'm making my first DB, which in comparison to most of what I read in these posts should be pretty simple.
In designing my table layout I'm kinda at a standstill as I can't really figure out how to create a schedule table, or more likely a set of schedule tables.
My DB's function (this part of it) is to create several classes in which to place students, each class potentially has two or more times throughout the week, and some students can be in multiple classes.
I'm not looking for code or specifics, just ideas on table structure.
I know that this seems simple to many of you, but I just can't seem to figure out how to structure it correctly. Thanks in advance for any advice given.
I'm making my first DB, which in comparison to most of what I read in these posts should be pretty simple.
In designing my table layout I'm kinda at a standstill as I can't really figure out how to create a schedule table, or more likely a set of schedule tables.
My DB's function (this part of it) is to create several classes in which to place students, each class potentially has two or more times throughout the week, and some students can be in multiple classes.
I'm not looking for code or specifics, just ideas on table structure.
I know that this seems simple to many of you, but I just can't seem to figure out how to structure it correctly. Thanks in advance for any advice given.