Database Design and Relational Theory: Normal Forms and All That Jazz
Material type:
TextPublication details: Apress Media LLC USA 2019Edition: 2nd EdDescription: 451pISBN: - 9781484255391
- 005.756 DAT
| Item type | Current library | Item location | Collection | Call number | Status | Date due | Barcode | Item holds | |
|---|---|---|---|---|---|---|---|---|---|
Reference Book
|
NIMA Knowledge Centre | 7th Floor Silence Zone | Reference | 005.756 DAT (Browse shelf(Opens below)) | Not For Loan | T0052452 |
Contents
About the Author
Preface to the First Edition
Preface to the Second Edition
Part 1: Setting the Scene
Preliminaries
Prerequisites
Part 2: Functional Dependencies, Boyce/Codd Normal Form, and Related Matters
Normalization: Some Generalities
FDs and BCNF (Informal)
FDs and BCNF (Formal)
Preserving FDs
FD Axiomatization
Denormalization
Part 3: Join Dependencies, Fifth Normal Form, and Related Matters
JDs and 5NF (Informal)
JDs and 5NF (Formal)
Implicit Dependencies
MVDs and 4NF
Part 4: Further Normal Forms
ETNF, RFNF, SKNF
6NF
The End is Not Yet
Part 5: Orthogonality
The Principle of Orthogonal Design
Part 6: Redundancy
We Need More Science
Part 7: Appendixes
Appendix A: What is Database Design, Anyway?
Appendix B: More on Consistency
Appendix C: Primary Keys Are Nice but Not Essential
Appendix D: Historical Notes
Index
There are no comments on this title.