
Information Structure Design for Databases
A Practical Guide to Data Modelling
Free Global Shipping
No minimum orderDescription
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
There are currently no reviews for "Information Structure Design for Databases"