Please enable JavaScript.
Coggle requires JavaScript to display documents.
DBMS - Coggle Diagram
DBMS
1NF
Each filed name and record should be unique
atomic
Separate table for each set of related data
No repeating data
no multivalued fields
Dependency
Functional
attribute dependent on primary key attribute
Partial
non key attribute is dependent on part of composite key
Transitive
non-prime attribute is dependent on another non-prime attribute
2NF
Meet requirements of 1NF
No partial dependency
3NF
Meet requirements of 2NF
No transitive dependency