Database design for mere mortals a hands-on guide to relational database design

“This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike’s approach whilst simple is completely professional, and I can recommend this book to any novice database designer.” – Sandra Barker , Lecturer, University o...

Descripción completa

Detalles Bibliográficos
Autor principal: Hernandez, Michael J. 1955- (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Boston : Addison-Wesley c2003.
Edición:2nd ed
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627235206719
Tabla de Contenidos:
  • 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.