Entity Relationship

[dfean]

Hiya,



If I have two tables, one for Memberships and one for Season tickets, if one member can only have one season ticket in their name, does that make it a one-to-many relationship or a one-to-one relationship.

[orange]

What do you think? Why? Are there more things/entities in your set up?

Watch this video for more info.

[ItsMe]

I always root for the winning team and fly around the country to visit home games. On the other hand, I only have one telephone number.