Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Normalization

Normalization

Thread began 6/13/2011 6:41 pm by madelectrical386948 | Last modified 6/30/2011 2:48 pm by madelectrical386948 | 7090 views | 33 replies

6/13/2011 6:41 pmmadelectrical386948

Normalization

After reading up on databases and how to set them up, its key to break up the database into sections. I understand that and how to make foreign keys.
I have created one database with 12 tables. Some of the tables are not connected to each other. Others I want to connect.
Right now I am working with the Company Index table that has 9 fields.
companyID,companyName,companyShortName,CompanyAddressNo,companyAddressLine1,companyAddressline2,companyCity,companyState,companyZipCode
This table is the main table and the other tables have the companyName and companyID as the foreign key.
The 2nd table is the options table. I would like to use this as a switch to turn on an icon or off. optionTwitter,optionFacebook,optionWebpage,optionRank and optionLevel.

I would like to add data in the Company Index table and have each and every table with the companyName and companyID to update.

Does this make sense and the correct way to do this?

Mike

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.