An excellent on designing relational databases is Database Design for Mere
Mortals by Michael J. Hernandez. It has definitely helped me.
Judith
Julie Clegg put into words:
>hello,
>
>I am putting together a database and I cannot decide what to do with the
>Education Table. I have 1000 clients who I need to enter their education
>level. For example, did they graduate from highschool and if so, what is
>the name of their highschool. Should I put that info on the same table or
>create a new table with the clientid and the name of the highchool attended
>if they did attend. I know that if I put it all on one table there will be
>a lot of empty fields but I also didnt know if it was "wasteful" to create
>such a small table just for highschool name.
>
>What do you think? Will the system slow down if I have ALOT of tables?
>
>Thanks,
>
>Julie
Judith Taylor
ICQ: 67460562
Freelance ColdFusion Developer
Freinds don't let friends code before coffee.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
