Information Structure Design for Databases (eBook)

A Practical Guide to Data Modelling

Andrew J. Mortimer (Autor)

eBook Download: PDF

2014 | 1. Auflage
248 Seiten
Elsevier Science (Verlag)
978-1-4831-8379-4 (ISBN)

Infos

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.

Inhalt

Front Cover 1
Information Structure Design for Databases: A Practical Guide to Data Modelling 4
Copyright Page 5
Table of Contents 12
Foreword 10
List of Figures 18
Preface 22
CHAPTER 1. 
28 
Tables 28
Relationships 30
New Concepts 31
Summary 33
CHAPTER 2. DATA AND INFORM.TI.. 34
What is Information? 34
Cost and Value of Information 36
Data and Information Differ 38
Quality of Information 38
Importance of Data Modelling 41
Summary 43
CHAPTER 3. BUSINESS ANALYSIS 44
The Information Environment 44
Types of Information System 45
Data Driven Systems 48
The User Community 49
The Business Analyst 52
Summary 57
CHAPTER 4. ENTITY REL.TI..S... MODEL BASICS 58
What is an Entity Relationship Model? 58
Elements of the ERM 60
The Entity 61
Relationships 66
Degree of Relationship Symbols 66
Membership Markers 68
Relationship Rules 70
Steps in ER Modelling 71
Techniques Work Together 73
Summary 75
CHAPTER 5. ..TI.. RELATIONSHIPS MODELLING CONNECTIONS 78
Entity Relationship Model Connections 78
Resolving Many-To-Many Relationships 78
Connection Traps 81
Chasm Traps 83
Summary 86
CHAPTER 6. FIVE-.-SIDE FOOTBALL LEAGUE 88
General Information 88
Discussion 90
Data Tables 95
Relationship Rules 96
Notes 97
CHAPTER 7. 
102 
The One-To-One Relationship 102
One-To-One Memberships 103
Attribute or Entity? 106
Keeping One-To-One Separate 107
Snapshot or History 107
Summary 109
CHAPTER 8. ENTITY RELATIONSHIP MODELLING ADVANCED TOPICS 110
Positional Semantics 110
Four Combinations of Membership 113
Default Membership 114
Entity Merging 116
Multiple Relationship Lines 123
Recursive Relationships 125
Summary 129
CHAPTER 9. LOGICAL DATA DICTIONARY 130
Data Tables 130
Database Creation 130
SQL 131
Table Names 132
Indexes 132
Metadata 132
Third Normal Form Tables 135
First Normal Form Rule 136
Second Normal Form Rule 137
Third Normal Form Rule 137
Unnormalised Data 138
Physical Data Dictionary 139
Denormalisation 140
Relational Database Enquiries 140
Summary 144
CHAPTER 10. DATA FLOW DIAGRAMS 146
What is a Data Flow Diagram? 146
Data vs Functionality 148
DFD Elements 150
Illegal Data Flow Linkages 155
Zero Level DFD 157
Decomposition of DFDs 157
Conservation of Data 158
Summary 160
CHAPTER 11. ENTITY LIFE HISTORY 162
The Entity Life History 162
Nodes 164
Sequence 164
Selection 165
Iteration 166
Level of Design Detail 166
Summary 168
CHAPTER 12. JACK GOLD MUSICAL AGENT 172
General Information 172
Discussion 172
Relationship Rules 176
Data Tables 176
CREATE Statements 177
Notes 179
CHAPTER 13. L & I SHIPPING COMPANY
General information 184
Discussion 185
Relationship Rules 188
Data Tables 191
CREATE Statements 192
Notes 194
CHAPTER 14. DEVELOPING DATABASE APPLICATIONS 200
Data Modelling During Development 200
Waterfall Approach 200
Iterative Approach 203
Feasibility 204
Analysis and Design 205
First Prototype 205
Iterative Development 206
Commissioning 207
System Evolution 207
Summary 209
CHAPTER 15. INFORMATION RESOURCE MANAGEMENT 210
The Management of Information 210
Evolutionary Information Systems 210
Database 211
Fourth Generation Development 213
Data Modelling 214
Database Philosophy 215
Disconnected Data Structures 216
The Database Administrator 218
Database Access Security 219
Integrity and Backup 223
Change Control 225
Database Tuning 225
User Liaison 226
Database Documentation 226
The Data Analyst and Data Security 227
Database Management Systems (DBMS) 227
Summary 229
FURTHER READING 232
GLOSSARY OF TERMS 234
APPENDIX A: 
240 
What Is SSADM? 240
Exclusive Relationships In SSADM 243
Membership Marking In SSADM 244
Normalisation 244
Index 246

Produkt-Details

• Erscheint lt. Verlag: 12.5.2014
• Sprache: englisch
• Themenwelt: Informatik ► Theorie / Studium ► Algorithmen
• ISBN-10: 1-4831-8379-3 / 1483183793
• ISBN-13: 978-1-4831-8379-4 / 9781483183794