Normalization

[U810190]

I am working at fundamentally understanding normalization for my database as I put together my building plan.

As far as tables go:

Say I have a company that has several different types of contracts (i.e. EEI, NAESB, ISDA); should I create a separate table so to list every company with a different contract type?

[ConneXionLost]

It depends on what you mean by "types of contracts" (I don't know what your acronyms mean), and what you expect the database to do for you.

"tblCompany" would probably be a parent table for you. "tblContractType" might be a lookup table? Then you would likely have a "tblContract" to list each individual contract.

Good Luck!