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 --
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
โ Scribed by Michael J. Hernandez
- Book ID
- 127434914
- Publisher
- Addison-Wesley Professional
- Year
- 2003
- Tongue
- English
- Weight
- 6 MB
- Edition
- 2
- Category
- Library
- ISBN-13
- 9780201752847
No coin nor oath required. For personal study only.
โฆ Synopsis
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 practical implications. Hernandez covers all the basics - table and field structure, keys, relationships, business rules, and more - but always keeps his feet on the ground with advice for real-world implementations and a particularly strong section on analyzing your current database infrastructure.
๐ 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