A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

INDEX

A

abstraction layers, 20–21

defined, 241

examples of, 242

exposed and unexposed, 254

extensibility and flexibility of, 244–245

implementation of, 242, 247–254

related to logical model, 245–246

related to object-oriented programming, 246–247

and security, 21, 242–244

uses of, 242–245

Access (Microsoft), 10–11

advanced cardinality, 70, 217–218

AFTER trigger, 73–74

alphanumeric data types, 26–27, 54–55

length of, 26

ALTER statement, 67

ASCII, 26

attribute key words, 123

attributes, 24–25

defined, 15

determining, 135–138

flexibility vs. structure in, 176–178

incorrect data types for, 178–182

listing, 142, 161–162, 169–170

modeling columns using, 210–211

naming, 152–153, 210

mutivalued, 32

problems involving, 176–182

single-valued, 32

B

B-tree ...