System development life cycle sdlc

336
	aggregate functions, 112–114

Sarson, Trish, 194
scale, 218–219
schemas, 262–263

subschemas, 5
scripting languages, 258
second normal form, 156–158

compound conditions using OR, 105, 106 CREATE INDEX statements, 121–122 CREATE TABLE statements, 118–119

255–258 injection, 258

login credentials, 256
in Microsoft SQL Server, 259–261 monitoring and auditing, 267
need for, 247–248
network, 250–254
object privileges, 265

schema owner accounts, 263–264 self-joins, 110

scripting languages, 258 simple WHERE clause, 103

INDEX 337

subselects, 106–108
tuning tips, 284–285
UPDATE statements, 116–117 See also Java SQL
SQL Plus, 91–96

SQL Plus Worksheet, 91, 93–96 SQL Server. See Microsoft SQL Server SQL/DS, 18
SSI, 239 star schema data warehouse architecture, 297–299 state, 184 statement privileges, 261

intersection, 41–42
joining, 70–72, 73, 108–111
listing entire Customers table, 62–63 naming conventions, 211

subschemas, 5 virtual, 45

super classes, 184 transactions

super types, 184–188, 208–210 ACID, 276

database security in, 259–261 symmetric keys, 256
synonyms, 100, 213

support in Microsoft SQL Server, 277–278 support in Oracle, 278
transitive dependencies, 158–160