What you have done
Find example of Normal form : 1NF , 2NF and 3NF from textbook.
In the example is about DreamHome lease, Simplification lease example
 |
| DreamHome Lease |
 |
| An unnormalized table from DreamHome Lease. |
DreamHome Lease in 1NF
 |
| Definition of First Normal Form. |
 |
| First Normal Form ClientRental relational. |
DreamHome Lease in 2NF
 |
| Definition of Second Normal Form. |
 |
| Functional dependencies of the ClientRental relational. |
 |
| Second Normal Form relations derived from the ClientRental Relational. |
DreamHome Lease in 3NF
 |
| Definition of Second Normal Form. |
 |
| Third Normal Form relations derived from the PropertyOwner Relational. |
 |
| Summary of 3NF relations derived from CluentRental Relation. |
Reference
Database Systems - 4th Edition
THOMAS M. CONNOLLY • CAROLYN E. BEGG
ไม่มีความคิดเห็น:
แสดงความคิดเห็น