Information Structure Design for Databases

ForewordPrefaceChapter 1 Data Analysis is Easy Tables Relationships New Concepts SummaryChapter 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 SummaryChapter 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 SummaryChapter 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 SummaryChapter 5 Entity Relationship Modeling Connections Entity Relationship Model Connections Resolving Many-To-Many Relationships Connection Traps Fan Traps Chasm Traps Bypass Solution Override Solution SummaryChapter 6 Five-A-Side Football League General Information Discussion Data Tables Relationship Rules NotesChapter 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 SummaryChapter 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 SummaryChapter 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 SummaryChapter 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 SummaryChapter 11 Entity Life History The Entity Life History Nodes Sequence Selection Iteration Level of Design Detail SummaryChapter 12 Jack Gold Musical Agent General Information Discussion Relationship Rules Data Tables CREATE Statements NotesChapter 13 L & I Shipping Company General Information Discussion Relationship Rules Data Tables CREATE Statements NotesChapter 14 Developing Database Applications Data modeling During Development Waterfall Approach Iterative Approach Feasibility Analysis and Design First Prototype Iterative Development Commissioning System Evolution SummaryChapter 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) SummaryGlossaryAppendix A: SSADM What Is SSADM? Exclusive Relationships In SSADM Membership Marking In SSADM NormalizationIndex