Normalization--design setup re repeated data

[lmcc007]

I am creating a database from my Excel spreadsheet. I have an issue with
normalization. I have two separate tables—tblCompanies and tblCompanyNames.
tblCompanies gives other data about the company—such as, size, industry,
press awards, and so on. tblCompanyNames only list the company names and
(N/A) when it is a blind ad, which I currently have about 400 blind ads I
responded to. I do not want duplicate company names in database.

Should I have one table (tblCompanies) and leave the company name field
blank? Is there another approach to handling situations like this?

 

[Gina Whipp]

lmcc007,

I would suggest two tables...

tblCompanyProfile
cpCompanyID (PK: Autonumber)
All 'parent' information here, such as Company name, size, industry, etc...

tblCompanyInformation
ciCompanyID (FK)
All 'child' information here, such as, press awards, etc...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[lmcc007]

Yes, I have separate tables for each subject. I got confused on the
CompanyName issue because about 400 records do not have a company name. The
reason being is because I am responding to blind ads that give only the fax
number, address, and so on.

 

[Gina Whipp]

lmcc007,

You can store the Company Name in tblCompanyProfile. Just do not use a PK
that way if you don't have the name, no problem! Then you can use a query
to join the two tables and show Comany Names where they exist.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[lmcc007]

Okay, thanks!

lmcc007,

You can store the Company Name in tblCompanyProfile. Just do not use a PK
that way if you don't have the name, no problem! Then you can use a query
to join the two tables and show Comany Names where they exist.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm