Many to Many or One to Many?

[Mtyetti]

Quick question on database relationships.



I have a pilot database I am creating. For each flight that is flown, there are 2 employees (pilots) assigned to the flight. My 'Event' table which represents the flight, has 2 employee fields. One for 'Captain, and one for Co-captain. I want both of these fields to pull employees from the same employee table. Would this technically be a Many to Many relationship because I have many employees that can fly many events. Or is it a One to Many because only one employee can be a Captain for many events? (and only one co-captain per event)

Hope this makes sense.

Thanks for the help!
Scott

[pbaldy]

One to many, because an employee will only be present once in the employee table.

[pbaldy]

By the way, a normalization case could be made for a separate table to hold the pilots. In a sense you have employee1 and employee2. That said, it isn't clear cut and if there will always be the 2 I might leave it as is.