Data Analysis for Database Design

• Increased material on SQL including the latest developments
• Practical approach to explaining techniques and concepts
• Very accessible but not superficial style
• Many questions and answer pointers

With new databases coming online all the time and the general expansion of the information age, it is increasingly important to ensure that the analysis and model of a database design is accurate and robust. This is an ideal book for helping you to ensure that your database is well designed and therefore user friendly.

Contents

• Part 1: Databases and database management systems:
• Database systems.
• Database management system architecture.
• Part 2: Relational modelling:
• Tables.
• Redundant vs duplicated data.
• Repeating groups.
• Determinants and identifiers.
• Fully-normalised tables.
• Part 3: Entity-relationaship modelling.
• Introduction to entity-relationship modelling.
• Properties of relationships.
• Decomposition of many:many relationships.
• Connection traps.
• Skeleton entity-relationship models.
• Attribute assignment.
• First-level design.
• Second level design.
• Part 4: Further topics.
• Distributed database systems.
• Relational algebra.
• Query optimnisation.
• The SQL language.
• Object orientation.
• Appendix: The Codasyl (network) model.