Hi Mark,
On Fri, Mar 23, 2012 at 7:29 PM, Mark Phillips
wrote:
> I have a servlet/jsp/MySQL web site in production, and there are about
> 2,000 records in the flights table. One of the foreign keys is teacher_id.
> Up to this point, there is a one to many relationship between teacher_id
> and the
Mark,
The current scenario sounds like:
"Each teacher can be assigned one or more flights, but each flight can have one and only one
teacher". The new scenario sounds like it would be "Each teacher can be assigned one or
more flights and each flight can have one or more teachers."
To create th
I have a servlet/jsp/MySQL web site in production, and there are about
2,000 records in the flights table. One of the foreign keys is teacher_id.
Up to this point, there is a one to many relationship between teacher_id
and the data in the flights table. I need to change the data model to allow
for
