File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 REST with Spring (video course) this week in the Spring 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
I agree. Here's the link:
subject: HF-SQL: Design choices
It's not a secret anymore!