CODEWITHSUNDEEP
databasedatabase-design
zan
zan

Reputation: 95

splitting table

I have the following table which holds data on customers and staff. Would it be beneficial if I split it into 2 separate tables: Persons and Address? Each single person can have only one address, phone and mobile. I have a separate table for orders.

My database is quite complex and I wonder if this would be useful for implementation.

Many thanks, zan

_______________
Persons        |
_______________|
PersonID       |
FirstName      |
LastName       |
OrderName      |
Email          |
Telephone      |
Mobile         |
StreetAddress  |
City           |
RegionID FK    |
Country        |
PostCode       |
TitleID  FK    |
PersonCat FK   |
MailingList    |
_______________|

Upvotes: 1

Views: 61

Answers (1)

Tom van der Woerdt
Tom van der Woerdt

Reputation: 29975

Only split tables when it's for normalizing purposes: for example, if one person can have multiple addresses or if less than a certain amount of people have an address (let's say 90%), which would result in a lot of NULL values.

If it's not for normalizing, don't split tables.

Upvotes: 4

Related Questions