I'm trying to save user data. I ran into this question. A town has got many streets. A street has a name. So a town has many streets. But has a street many towns? At first you would say the street only has one town. But that name will be present in many towns. I could do the following: A town has many streets A street has one town A street has a relationship to another Table called Streetname That streetname would have a n to n relationship to street. Your insights?