Data Analysis for Database Design,
Edition 3Editors: By David Howe
Note
-
This product relies on 3rd party tooling which may impact the accessibility features visible in inspection copies. All accessibility features mentioned would be present in the purchased version of the title.
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 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.
Key Features
- Increased material on SQL including the latest developments
- Practical approach to explaining techniques and concepts
- Contains many questions and answer pointers
About the author
By David Howe, Professor, formerly at Department of Computing, de Montfort University, UK
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