Names, Addresses and Other Uncertainties

I was working on a little database on a project I’m working. The issue  that arose is the storage of names and addresses. Ideally, I wanted the  number of names to be variable, and the person’s birth and death address  stored. So this was Draft A.

The problem with this, as you can see, is that the number of names is  not variable (unless I add a finite number of name fields and leave the  unused ones blank. Also, there’s too much address information stored in  the Person table. Person is supposed to be about a person.

The solution?

The address table is responsible for storing addresses. The PersonName  table allows the number of names stored to be as many as a person would  like. And the DisplayName table by default stores a concatenation of all  the names in their order, but can be edited if necessary.

Now my question is, isn’t there some standardised formula for storing addresses?

*The reason for having both the TownId and CountryId stored in the same  table is because a person may not enter a town, but enter a country.  This needs to be stored.

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s