Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What is 3rd normal form?
- Thread starter ADR1985
- Start date
ADR1985,
Oversimplified:
First Normal Form-No repeating groups
Second Normal Form-No repeating groups AND any field that is not a key field is is dependent on the primary key
Third Normal Form-No repeating groups AND any field that is not a key field is is dependent on the primary key AND the value in a field (not a primary key field) is determined by the value in another field (again, not a primary key field).
How to do it:
1. Read up on relational database design.
2. Look for repeating values. Repeating data usually means you need to create an additional table.
HTH, Montrose Learn what you can and share what you know.
Oversimplified:
First Normal Form-No repeating groups
Second Normal Form-No repeating groups AND any field that is not a key field is is dependent on the primary key
Third Normal Form-No repeating groups AND any field that is not a key field is is dependent on the primary key AND the value in a field (not a primary key field) is determined by the value in another field (again, not a primary key field).
How to do it:
1. Read up on relational database design.
2. Look for repeating values. Repeating data usually means you need to create an additional table.
HTH, Montrose Learn what you can and share what you know.
- Status
Similar threads
- Locked
- Question
- Locked
- Question