Information Structure Design for Databases

Information Structure Design for Databases

A Practical Guide to Data Modelling

1st Edition - March 31, 1993

Write a review

  • Author: Andrew J. Mortimer
  • eBook ISBN: 9781483183794

Purchase options

Purchase options
DRM-free (PDF)
Sales tax will be calculated at check-out

Institutional Subscription

Free Global Shipping
No minimum order

Description

Computer Weekly Professional Series: Information Structure Design for Databases: A Practical Guide to Data modeling focuses on practical data modeling covering business and information systems. The publication first offers information on data and information, business analysis, and entity relationship model basics. Discussions cover degree of relationship symbols, relationship rules, membership markers, types of information systems, data driven systems, cost and value of information, importance of data modeling, and quality of information. The book then takes a look at entity relationship modeling connections, one-to-one relationship, and entity relationship modeling advanced topics, including connection traps, resolving many-to-many relationships, four combinations of membership, and entity merging. The text examines logical data dictionary, data flow diagrams, entity life history, and developing database applications. Topics include data modeling during development, waterfall approach, iterative development, sequence, selection, illegal data flow linkages, conservation of data, second normal form rule, and denormalization. The book is a valuable reference for researchers interested in data modeling.

Table of Contents


  • Foreword

    Preface

    Chapter 1 Data Analysis is Easy

    Tables

    Relationships

    New Concepts

    Summary

    Chapter 2 Data and Information

    What is Information?

    Cost and Value of Information

    Data and Information Differ

    Quality of Information

    Timeliness of Information

    Accuracy of Information

    Relevance of Information

    Meaningfulness of Information

    Availability of Information

    Importance of Data modeling

    Summary

    Chapter 3 Business Analysis

    The Information Environment

    Types of Information System

    Accounting Systems

    Inventory and Stock Management

    Order Management Systems

    Manufacturing Systems

    Data Driven Systems

    The User Community

    Understanding the User Environment

    The Business Analyst

    The Hybrid Manager

    Understanding Expectations

    Managing Expectations

    User Contact

    User as Verifier of the Data Model

    Information Gathering

    Summary

    Chapter 4 Entity Relationship Model Basics

    What is an Entity Relationship Model?

    Elements of the ERM

    Alternative Symbol Conventions

    The Entity

    Types of Entity

    Continuous Entities

    Unique Identifier

    Attributes

    Relationships

    Degree of Relationship Symbols

    Membership Markers

    Relationship Rules

    Steps in Ε R ModeUing

    Other Data Modeling Tools

    Soft Technique

    Logical not Physical

    Techniques Work Together

    Summary

    Chapter 5 Entity Relationship Modeling Connections

    Entity Relationship Model Connections

    Resolving Many-To-Many Relationships

    Connection Traps

    Fan Traps

    Chasm Traps

    Bypass Solution

    Override Solution

    Summary

    Chapter 6 Five-A-Side Football League

    General Information

    Discussion

    Data Tables

    Relationship Rules

    Notes

    Chapter 7 One-To-One

    The One-To-One Relationship

    One-To-One Memberships

    Both Mandatory

    Both Optional

    One Entity Mandatory, One Optional

    Attribute or Entity?

    Keeping One-To-One Separate

    Snapshot or History

    Summary

    Chapter 8 Entity Relationship Modeling Advanced Topics

    Positional Semantics

    Hierarchical Diagramming

    Four Combinations of Membership

    Default Membership

    Entity Merging

    Multiple Relationship Lines

    Recursive Relationships

    Implementing Recursive Relationships

    Summary

    Chapter 9 Logical Data Dictionary

    Data Tables

    Database Creation

    SQL

    Table Names

    Indexes

    Metadata

    Third Normal Form Tables

    First Normal Form Rule

    Second Normal Form Rule

    Third Normal Form Rule

    Unnormalized Data

    Physical Data Dictionary

    Denormalization

    Relational Database Enquiries

    Summary

    Chapter 10 Data Flow Diagrams

    What is a Data Flow Diagram?

    Data vs Functionality

    Understanding the Environment

    Process Analysis for DFDs

    DFD Elements

    Data Stores

    Externals

    Processes

    Data Flows

    System Boundary

    Physical Flows

    Illegal Data Flow Linkages

    Zero Level DFD

    Decomposition of DFDs

    Conservation of Data

    Summary

    Chapter 11 Entity Life History

    The Entity Life History

    Nodes

    Sequence

    Selection

    Iteration

    Level of Design Detail

    Summary

    Chapter 12 Jack Gold Musical Agent

    General Information

    Discussion

    Relationship Rules

    Data Tables

    CREATE Statements

    Notes

    Chapter 13 L & I Shipping Company

    General Information

    Discussion

    Relationship Rules

    Data Tables

    CREATE Statements

    Notes

    Chapter 14 Developing Database Applications

    Data modeling During Development

    Waterfall Approach

    Iterative Approach

    Feasibility

    Analysis and Design

    First Prototype

    Iterative Development

    Commissioning

    System Evolution

    Summary

    Chapter 15 Information Resource Management

    The Management of Information

    Evolutionary Information Systems

    Database

    Fourth Generation Development

    Data modeling

    Database Philosophy

    Disconnected Data Structures

    The Database Administrator

    Database Access Security

    Views

    Metadata Security

    Integrity and Backup

    Change Control

    Database Tuning

    User Liaison

    Database Documentation

    The Data Analyst and Data Security

    Database Management Systems (DBMS)

    Summary

    Glossary

    Appendix A: SSADM

    What Is SSADM?

    Exclusive Relationships In SSADM

    Membership Marking In SSADM

    Normalization

    Index

Product details

  • No. of pages: 248
  • Language: English
  • Copyright: © Butterworth-Heinemann 1993
  • Published: March 31, 1993
  • Imprint: Butterworth-Heinemann
  • eBook ISBN: 9781483183794

About the Author

Andrew J. Mortimer

Ratings and Reviews

Write a review

There are currently no reviews for "Information Structure Design for Databases"