Data analysis for database design
Data analysis for database design is a subject of great practical value to systems analysts and designers. This classic text has been updated to include chapters on distributed database systems, query optimisation and object-orientation.The SQL content now includes features of SQL92 and SQL 99.With...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Oxford ; Boston :
Butterworth Heinemann
2001.
|
| Edición: | 3rd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627871306719 |
Tabla de Contenidos:
- Front Cover; Data Analysis for Database Design; Copyright Page; Contents; Preface to the Third Edition; Readership; Scope; Structure and content; Terminology; Questions and assignments; Comparison with the second edition; Acknowledgements; Part A: Introduction; Database; Torg Ltd; Analysis; Answer pointers; Part 1: Databases and database management systems; Chapter 1. Database systems; The database approach; Program/data independence; Other database management system facilities; What constitutes a database management system?; Disadvantages; Database vs database management system
- Scope of a databaseAssignment; Answer pointers; Chapter 2. Database management system architecture; Introduction; A three-level architecture; The conceptual schema; The external schema; The internal schema; Mapping; DBMS components; Advantages of three-level architecture; Data administration; Model vs schema; Terminology; Assignments; Answer pointers; Part 2: Relational modeelling; Chapter 3. Tables; Introduction; Tables; Nulls; Normalisation; Answer pointers; Chapter 4. Redundant vs duplicated data; Introduction; Redundant vs duplicated data; Elimination of redundancy; Deceptive appearances
- Enterprise rulesAnswer pointers; Chapter 5. Repeating groups; Introduction; Repeating groups; Elimination of repeating groups (normalisation); Assignments; Separate attribute types; Answer pointers; Chapter 6. Determinants and identifiers; Introduction; Determinants; Superfluous attributes; Determinancy; Composite determinants; Transitive determinants; Terminology; Assignment; Identifiers; Determinancy diagrams and redundancy; Transformation into well-normalised tables; Notation; Assignment; Answer pointers; Chapter 7. Fully-normalised tables; Introduction; Hidden transitive dependency
- Multi-valued determinancyAdvantages of full normalisation; Normal forms; Assignments; Answer pointers; Part 3: Entity-relationship modelling; Chapter 8. Introduction to entity-relationship modelling; Bottom-up data modelling; Entity-relationship modelling; Type vs occurrence; Identifiers; Entity-relationship diagrams; Answer pointers; Chapter 9. Properties of relationships; The degree of a relationship; Determinancy constraints; Participation conditions; Multiplicity; Choice of notation; Answer pointers; Chapter 10. Decomposition of many:many relationships; Decomposition; Answer pointers
- Chapter 11. Connection trapsIntroduction; Misinterpretation; Fan traps; Chasm traps; Further fan traps; Decomposition of complex relationships; Summary; Answer pointers; Chapter 12. Skeleton entity-relationship models; Introduction; Representation of 1:1 relationships; Representation of 1:many relationships; Representation of many:many relationships; Preposted identifiers; Skeleton tables; Relationship identifiers; Relationship vs row identifiers; Review; Recursive relationships; Answer pointers; Chapter 13. Attribute assignment; Assignment rules; 1:1 relationships; 1:many relationships
- Many:many relationships
