tailieunhanh - Beginning Database Design- P25

Beginning Database Design- P25:This book focuses on the relational database model from a beginning perspective. The title is, therefore, Beginning Database Design. A database is a repository for data. In other words, you can store lots of information in a database. A relational database is a special type of database using structures called tables. Tables are linked together using what are called relationships. You can build tables with relationships between those tables, not only to organize your data, but also to allow later retrieval of information from the database | field Index potential hazards 49 2NF 89-96 284-285 star schema turning into snowflake schema 178-181 3NF 96-103 284 285-286 287-288 dynamic data defined 408 indexing 207 table indexing 339 dynamic strings ANSI datatype 330 described 43 419 E employee database sample composite table 117 denormalizing table 155-157 159-160 dependencies multiple valued 80 normalizing table BCNF 110-111 5NF 118-121 4NF 112-116 3NF 97-98 101-103 encoding business rules data warehouse database model 374 OLTP database model 373-374 end-users analysis 222 data modeling for 23 defined 408 needs listening to company objectives 226 importance of 27-28 invoices 227-228 number of client-server database 195 data warehouse database 196 OLTP database 194 performance 193 power user versus 357 entity ERD. See tables ERDs Entity Relationship Diagrams conceptual design 20 defined 3 408 simple database model 25 error trap 145 errors. See anomalies ERWin database modeling tool described 221-222 5NF tables 155 156 event. See stored procedures event triggers 27 363 418 excluding specific records 130-132 existing system analysis 222 usefulness 254 expression 202-203 408 external procedures code storing in database 364 described 408 F fact tables building 183 child records with optional parents 273 data mart as 197 described 168 408 dimensional database 175 190-191 247 location dimension 185-186 multiple joined by SQL code queries 248 online auction sample creating during design phase 268-269 normalizing 308-312 with referential integrity 279-282 snowflake schema 179 star schema 177 time dimension 184-185 fact-dimensional structure. See star schema failover database 397-399 417 fear of indexing overcoming 206 field business rules data warehouse database model 370-373 377-379 described 364 OLTP database model 364-370 374-377 data warehouse database sample 349-352 described 37-38 40-42 409 explicitly declared 357-358 indexing too many 65 453 field continued field continued OLTP database sample 346-348 .