Skip to main content
View Cart

Data Analysis for Database Design

  • 3rd Edition - May 31, 2001
  • Latest edition
  • Author: David Howe
  • Language: English

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 da… Read more

Early spring sale

Nurture your knowledge

Grow your expertise with up to 25% off trusted resources.

Shop now

Description

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

Readership

Undergraduate and HND/HNC students of computer studies, information technology and information systems

Table of contents

Part 1: Databases and database management systems: Database systemsDatabase management system architecture

Part 2: Relational modelling: TablesRedundant vs duplicated dataRepeating groupsDeterminants and identifiersFully-normalised tables

Part 3: Entity-relationaship modellingIntroduction to entity-relationship modellingProperties of relationshipsDecomposition of many:many relationshipsConnection trapsSkeleton entity-relationship modelsAttribute assignmentFirst-level designSecond level design

Part 4: Further topicsDistributed database systemsRelational algebraQuery optimnisationThe SQL languageObject orientationAppendix: The Codasyl (network) model

Review quotes

"...It has the very specific aim of explaining techniques and concepts. It does so from a very practical standpoint by drawing on reasonably small-scale examples. To allow the reader to measure comprehension at each stage selected exercises are provided. The 'answer pointers' at the end of the chapter readily reveal any lack of comprehension...This book is strongly recommended to serious students.....It is able to delve thoroughly into the area of data analysis and model design."—The Computer Journal. (Of the first edition)

Product details

  • Edition: 3
  • Latest edition
  • Published: June 12, 2001
  • Language: English

About the author

DH

David Howe

Affiliations and expertise
Professor, formerly at Department of Computing, de Montfort University, UK

View book on ScienceDirect

Read Data Analysis for Database Design on ScienceDirect