Information Structure Design for Databases - 1st Edition - ISBN: 9780750606837, 9781483183794

Information Structure Design for Databases

1st Edition

A Practical Guide to Data Modelling

Authors: Andrew J. Mortimer
eBook ISBN: 9781483183794
Imprint: Butterworth-Heinemann
Published Date: 31st March 1993
Page Count: 248
Tax/VAT will be calculated at check-out Price includes VAT (GST)
30% off
30% off
30% off
30% off
30% off
20% off
20% off
30% off
30% off
30% off
30% off
30% off
20% off
20% off
30% off
30% off
30% off
30% off
30% off
20% off
20% off
72.95
51.06
51.06
51.06
51.06
51.06
58.36
58.36
43.99
30.79
30.79
30.79
30.79
30.79
35.19
35.19
54.95
38.47
38.47
38.47
38.47
38.47
43.96
43.96
Unavailable
Price includes VAT (GST)
× DRM-Free

Easy - Download and start reading immediately. There’s no activation process to access eBooks; all eBooks are fully searchable, and enabled for copying, pasting, and printing.

Flexible - Read on multiple operating systems and devices. Easily read eBooks on smart phones, computers, or any eBook readers, including Kindle.

Open - Buy once, receive and download all available eBook formats, including PDF, EPUB, and Mobi (for Kindle).

Institutional Access

Secure Checkout

Personal information is secured with SSL technology.

Free Shipping

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

Details

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

About the Author

Andrew J. Mortimer