Relational databases are powerful tools for organizing data, but learning to use them effectively can be painful. Relational Database Design for Mere Mortals explains the concepts of relational-database design in an easy-to-digest fashion that covers both the theoretical underpinnings and their prac
Database design for mere mortals. A hands-on guide to relational database design
โ Scribed by Hernandez M.J.
- Book ID
- 127458877
- Year
- 2003
- Tongue
- English
- Weight
- 6 MB
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
Pt. I. Relational Database Design -- Ch. 1. Relational Database -- Ch. 2. Design Objectives -- Ch. 3. Terminology -- Pt. II. Design Process -- Ch. 4. Conceptual Overview -- Ch. 5. Starting the Process -- Ch. 6. Analyzing the Current Database -- Ch. 7. Establishing Table Structures -- Ch. 8. Keys -- Ch. 9. Field Specifications -- Ch. 10. Table Relationships -- Ch. 11. Business Rules -- Ch. 12. Views -- Ch. 13. Reviewing Data Integrity -- Pt. III. Other Database-Design Issues -- Ch. 14. Bad Design - What Not to Do -- Ch. 15. Bending or Breaking the Rules -- Pt. IV. Appendixes -- App. A. Answers to Review Questions -- App. B. Diagram of the Database-Design Process -- App. C. Design Guidelines -- App. D. Documentation Forms -- App. E. Database-Design Diagram Symbols -- App. F. Sample Designs
๐ SIMILAR VOLUMES
Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a "Mere Mortal" will indeed be empowered to perform the superhuman. Do not walk past
In this paper, the adequacy of fifth normal form (5NF) in relational database design is investigated. It is shown that 5NF is inadequate because it does not generalise fourth normal form (4NF) and because it is equivalent to the very stringent requirement that every attribute is a key, a requirement