0% found this document useful (0 votes)
10 views6 pages

Third Normal Form

Uploaded by

medtaherallem
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views6 pages

Third Normal Form

Uploaded by

medtaherallem
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Copyright© 2023 Mohammed Abu-Hadhoud

[Link] MBA, PMOC, PgMP®, PMP®, PMI-RMP®, CM, ITILF, MCPD, MCSD
26+ years of experience
Copyright© 2023 Mohammed Abu-Hadhoud
[Link] MBA, PMOC, PgMP®, PMP®, PMI-RMP®, CM, ITILF, MCPD, MCSD
26+ years of experience
Second Normal Form
3NF

Copyright© 2023 Mohammed Abu-Hadhoud


[Link] MBA, PMOC, PgMP®, PMP®, PMI-RMP®, CM, ITILF, MCPD, MCSD
26+ years of experience
3rd Normal Form (3NF)
Third Normal Form (3NF) is a higher level of database
normalization that builds on the rules of First Normal Form
(1NF) and Second Normal Form (2NF). It requires that each non-
key column in a table be dependent only on the primary key,
and not on any other non-key columns.

To satisfy the requirements of 3NF:


1. Table must first be in 1NF and 2NF, and then have:
2. No transitive dependencies: Each non-key column in the
table must be dependent only on the primary key, and not on
any other non-key columns.

Copyright© 2023 Mohammed Abu-Hadhoud


[Link] MBA, PMOC, PgMP®, PMP®, PMI-RMP®, CM, ITILF, MCPD, MCSD
26+ years of experience
Books

Copyright© 2023 Mohammed Abu-Hadhoud


[Link] MBA, PMOC, PgMP®, PMP®, PMI-RMP®, CM, ITILF, MCPD, MCSD
26+ years of experience
Copyright© 2023 Mohammed Abu-Hadhoud
[Link] MBA, PMOC, PgMP®, PMP®, PMI-RMP®, CM, ITILF, MCPD, MCSD
26+ years of experience

You might also like