If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
On Mon, 14 Feb 2005 11:47:03 -0600, "Tony Vrolyk" tvrolyk at mlhg dot
net wrote: I think I understand the basics and in msot cases my dbs have been normalized to a large degree A nitpick--normalization applies to tables, not to databases. I wasn't aware of the specific normalization types 1NF, 2NF and so on. I did a search and found this article - http://www.devshed.com/c/a/MySQL/An-...rmalization/1/ - Assuming it is accuratly written than I am at least designing my dbs to satisfy 3NF which I was happy to find out. "The Three Normal Forms" is a dead giveaway. There are at least seven, and I think Chris Date has recently written about another, but I could be wrong about that. There's a *lot* of misinformation about normalization and database design on the web. I don't think you can do better than Date's _Introduction to Database Systems_, and it's easy to do a lot worse. You can probably find a used copy pretty cheap, but get the seventh edition, at the very least. -- Mike Sherrill Information Management Systems |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
multiple docs, one data source | kp | Mailmerge | 12 | January 31st, 2005 04:41 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |