|Frames||Modems||Help||Home Page||Chipsets||Search||No Frames|
|Diary Entries||See also Site Info & Diary.|
|25 September 2001||Continuing building the Tables...
(from now on the starting & ending lines on previous diary entries are ommitted.)
|"Normalising" a database is the process of making sure that it's structure is as effective & efficient as possible. I've tried to do that on the list of manufacturers above. Each Field (individual lines between the brackets) will contain just one entry for each mfc - the only exception (used to be) the Name, but somehow it didn't seem right not to include a name within each record (a Record is a set of all the Fields within a table - an individual database is then the set of all the records stored, and a relational database is the set of all databases plus the relations between them).
What's needed now is lots of little databases containing things which can appear more than once with each manufacturer. They will be related to the mfc database via a MID field, which will contain the mfc.MID value from their manufacturer. That's the theory at least.
|The main thing that's missing now is the actual modems (!), but this will need the Chipset mfc pages to be constructed first, then the modems. Then the Help pages. Then Forms to fill the databases. Then PHP scripts to display the Website pages. Then changing half the organisation above as I discover new things. Oh, mama!
One other thing - I did download MySQLGUI from the MySQL download page (mysqlgui-win32-static-1.7.5-2.zip 668 KB) on the 21 Sep and it has finally proved useful in allowing me to copy the Create Table commands above - these are actually SQL Commands - from an IE HTML window & pasting them into the MySQLGUI window then executing them. Much quicker (once created) than typing them out all over again, and far easier when little mistakes are made to correct & re-issue.
Postscript - just so that you know what it is like at my end... 40 emails (6.5 MB) in one day waiting for me when I connected to my ISP - 1 from my website & 39 others, mostly viruses, some spam. These days I use POP3 Scan Mailbox to delete all the virus emails from the Server's mailbox. Don't ever send me attachments - your email will simply be deleted unread.