This week's book giveaway is in the Agile forum.
We're giving away four copies of The Software Craftsman and have Sandro Mancuso on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes HF-SQL: Design choices Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "HF-SQL: Design choices" Watch "HF-SQL: Design choices" New topic

HF-SQL: Design choices

Amit Wadhwaa
Ranch Hand

Joined: Feb 15, 2007
Posts: 74
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?

SCJP 5 94%<br /><a href="" target="_blank" rel="nofollow">My Blog</a>
Lynn Beighley
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
I'd add these:
Choosing Primary Keys
Choosing Foreign Keys
Normalizing (1NF, 2NF, 3NF)

Lynn Beighley<br />Author, Head First SQL
Have you tried LearnNowOnline?
subject: HF-SQL: Design choices