Does this violate first normal form?

[Mike Hildner]

I'm attempting to normalize a table that looks similar to this

Caller
Caller Address Block
Caller Address Street
Caller Address City
Location
Location Address Block
Location Address Street
Location Address City
Occurance
Occurance Address Block
Occurance Address Street
Occurance Address City

My first step was to get rid of the obvious and make it look like

Caller
Caller Address ID
Location
Location Address ID
Occurance
Occurance Address ID

When I look at that, it seems that several "...Address ID" columns qualifies as a repeating field. Should I move those into another table?

Thanks,
Mike

[szlamany]

If they are distinctly different address id's having nothing to do with each other, then in a way they are not repeating fields. Anymore than FIRSTNAME and LASTNAME are not repeating fields.

But you could also say that having an "address" table, where you key with whatever the primary key of this table is (you don't mention that) and have a sequence number or address type might be more helpful for you to maintain and code against.

In our student applications we have the MARKING PERIOD 1, MARKING PERIOD 2, MARKING PERIOD 3, MARKING PERIOD 4 and FINAL MARK all in the table table. I've seen designs that did not do this - but they had 500 tables - and we replaced them with our design

[Mike Hildner]

Thanks for the clarification. I wasn't sure whether that would be considered repeating or not, to me it seems ok. In a way it's similar to your MARKING PERIODs. And yes, there will be an address table.