CODEWITHSUNDEEP
mysqldatabasedatabase-design
CodeTalk
CodeTalk

Reputation: 3667

Should I normalize or de-normalize?

I have a table:

Person with columns:

pID(PK)
FName
LName
plID(FK)

Another table Place with:

plID(PK)
plCity
plState
plZip

Is it better to just have Person made like:

pID(PK)
FName
LName
City
State
Zip

For instance:

John Doe New York, NY 00000
Jane Doe New York, NY 00000
Jim Doe New York, NY 00000

Upvotes: 2

Views: 145

Answers (1)

kba
kba

Reputation: 19466

You should normalize a database to eliminate data redundancy. In your case, it is very likely that you'll have a lot of people from the same place, which would cause data redundancy.

Therefore the answer is yes. You should absolutely normalize your database. You could possibly just include the zip code in the Person table and let that be a foreign key in Person and primary key in Place.

Upvotes: 5

Related Questions