Hi Jim,
I agree with Bryan that you are off to a great start since you realize
that this is a topic which requires some design and thought. Last year I
ran a BOF at SIGSCE on the topic of teaching college level database
courses. It turned out that at American colleges today, the favorite
textbook on this topic is Ramakrishnan and Gehrke's Database Management
Systems:
http://www.agapea.com/libros/Database-Management-Systems-isbn-0071230572-i.htm
A little googling turned up the following slidedeck accompanying this
textbook:
http://pages.cs.wisc.edu/~dbbook/openAccess/thirdEdition/slides/slides3ed.html
Hope this helps,
-Rick
Bryan Pendleton wrote:
Are there any guideline articles or books that will help me in
designing my tables?
Here's a good place to start:
http://www.google.com/search?q=data+normalization
I am new to Database implementation and want to do this initial
design properly.
Well, you've made an excellent first step by realizing that this is
a topic worth thinking about. Too many people just dive right in,
so you're off to a great start by resisting that urge and thinking
about it first!
After you've thought about it some more, and read some of the
articles that are available, come back to this list with more
detailed questions and you'll certainly find people happy to
discuss this at length.
thanks,
bryan
