Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third Edition

Index

A

Abbreviations

in field names, 289, 294

in Field Specifications. 284

in table names, 188-189, 204

Accuracy of data, 17, 26

Acronyms

in field names, 511, 548

in Field Specifications, 284

in table names, 188-189, 204

Action-oriented questions, 335–336

Aggregate functions, effects of nulls, 49

Aggregate views, 442–446

Aliases element, 281–283

Alphanumeric data type, 288

Alternate keys, 260

Analytical databases, 4, 489–490

Analyzing current databases

adopting the current structure, 117–118

case study, 166–171

conducting interviews, 129–137

data collection, 121–124

in the design process, 78–79

goals of analysis, 117

human-knowledge databases, 117

information presentation, 125–129

legacy databases, 116–117, 119–121

overview, 115–118

paper-based ...