I'm building a database that will be containing over 700.000 companies. This i sa lot o data, so I have ti build the databse efficiently.
This is how I intend to do it. Read it an comment if it is a good way or a bad way of doing it.
Tablename - {Fields}
Organization - OrgID, orgName, tlf, fax, email, url, orgForm
OrganizationForm - orgForm (15 unique categories)
BusinessType - btID, description (an org may have several types)
Address - addID,StreetName, number
PostAddress - postAddID, PostNr, PostName/county
Contact - contID, Name, tlf, email
Employe - empID, Name. tlf, email
I was thinking that since I have allmost a million companies, it would be smart to have things like address and postnumber in separate tables - since they may appear several times.
I think it's called normalization?
I should also probably use indexing - though I'm not quite sure how that works.
Is there other things I should take under consideration when designing a DB for so much data?
