This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HF-SQL: Design choices" Watch "HF-SQL: Design choices" New topic
Author

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="http://amit-wadhwa.blogspot.com/" target="_blank" rel="nofollow">My Blog</a>
Lynn Beighley
author
Ranch Hand

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


Lynn Beighley<br />Author, Head First SQL
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HF-SQL: Design choices
 
Similar Threads
Web Architect-Toronto, Ontario, Canada
memory usage with EntityBeans
Interview suggestion
what is the meanning of Data inconsistencies are eliminated
Java discourages intelligent use of database technology: Discuss.