Information Structure Design for Databases
A Practical Guide to Data Modelling
- 1st Edition - March 31, 1993
- Author: Andrew J. Mortimer
- Language: English
- Paperback ISBN:9 7 8 - 0 - 7 5 0 6 - 0 6 8 3 - 7
- eBook ISBN:9 7 8 - 1 - 4 8 3 1 - 8 3 7 9 - 4
Computer Weekly Professional Series: Information Structure Design for Databases: A Practical Guide to Data modeling focuses on practical data modeling covering business and… Read more
Purchase options
Institutional subscription on ScienceDirect
Request a sales quoteComputer 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.
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
- No. of pages: 248
- Language: English
- Edition: 1
- Published: March 31, 1993
- Imprint: Butterworth-Heinemann
- Paperback ISBN: 9780750606837
- eBook ISBN: 9781483183794
Read Information Structure Design for Databases on ScienceDirect