I'm attempting to normalize an incredibly flat table. I find myself moving several "person" (Name, DOB, Sex, Height et.) and "address" (Block, Street Name etc.) groups out of this table and instead use a pointer to a "Names" and an "Addresses" tables.

Seems like that's what 2nd normal form says to do, but now I have a table that consists mostly of pointers to records in other tables. I'll have to flatten out this table via a view so the user/app can make use of it. I read once (can't remember where) that one should avoid more than four joins in a view because of the overhead.

Should I be concerned about this? Using MS Sql 2000.

Thanks,
Mike