Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HF-SQL: Design choices

 
Amit Wadhwaa
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
One of the difficulties I face as a programmer/ amateur application designer is how to decide on the tables and when to split them (normalize) and what kind of design. That is should I generally have Small no of large tables or Large no of small tables- From my point of view it comes to Ease of use/Performance vs Normalization/Ease of understanding(Really! I am not sure!)

The authors talk about covering normalization in another thread, what other db design topics are covered in the book?
 
Lynn Beighley
author
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'd add these:
One-to-One
One-to-Many
Choosing Primary Keys
Choosing Foreign Keys
Normalizing (1NF, 2NF, 3NF)
ACID
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic