New answers tagged normalization
3
votes
Help - Database design
In general a major concern for this type of problem is how often new fields will be added. In most places (and in my experience) new fields are added often. Business needs always change and grow, and ...
- 1,001
4
votes
Help - Database design
There may be several nation checks for each field (max is 42).
Today.
Tomorrow, someone will want number 43.
It's almost guaranteed.
Database != Spreadsheet
Create a table for each of the "30&...
- 7,443
Top 50 recent answers are included
Related Tags
normalization × 656database-design × 399
mysql × 95
relational-theory × 93
denormalization × 44
sql-server × 41
postgresql × 39
schema × 37
dependencies × 33
foreign-key × 23
performance × 21
primary-key × 15
best-practices × 13
erd × 13
optimization × 11
table × 9
database-theory × 8
relations × 8
query-performance × 7
join × 7
constraint × 7
oracle × 6
index × 6
nosql × 6
ms-access × 5