New answers tagged normalization
2
votes
Normalizing an old database
"Require no application code changes" is the right way to go at this stage.
Another alternative is to fully normalize the consumer table, which would remove the columns "firstname" ...
Top 50 recent answers are included
Related Tags
normalization × 641database-design × 394
mysql × 92
relational-theory × 92
denormalization × 42
sql-server × 41
schema × 36
postgresql × 34
dependencies × 31
foreign-key × 21
performance × 20
primary-key × 15
best-practices × 13
optimization × 12
erd × 12
table × 8
database-theory × 8
relations × 8
query-performance × 7
join × 7
constraint × 7
oracle × 6
index × 6
nosql × 6
null × 6