Database development and management

Title:

Personal Author:

Chao, Lee, 1951-

Series:

Foundations of database design series

Publication Information:

Boca Raton, FL : Auerbach Publications, 2006

ISBN:

9780849333187

Subject Term:

Database management

Database design

Available:*

Library	Item Barcode	Call Number	Material Type	Item Category 1	Status
Searching... PSZ JB	30000010134639	QA76.9.D3 C444 2006	Open Access Book	Book	Searching... Unknown
Searching... PSZ KL	30000010196923	QA76.9.D3 C444 2006	Open Access Book	Book	Searching... Unknown
Searching... SPACE Ipoh Library	30000010087708	QA76.9.D3 C444 2006	Open Access Book	Book	Searching... Unknown

Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications.

Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well as data analysis for business intelligence. This self-contained text gives students hands-on projects required for professionally developing and managing databases. It provides detailed instruction via an easy-to-follow, step-by-step case-based approach.

Following an introduction to database components, the book uses case studies to illustrate the modeling process, covers table structures and normalization, and analyzes the transformation of a data model to a relational database. It explains the use of SQL in managing database objects and in querying databases, then discusses Transact-SQL and the views, indexes, and cursors that bridge databases and their applications.

The book examines three major data-accessing techniques, and then shows how to develop sophisticated applications based upon the material included in previous chapters. It explores the use of databases in network environments, and details the multiple tasks handled by database administrators (DBAs).

The text also discusses the OnLine Analytical Processing (OLAP) system, data warehousing, and other analysis tools that support business intelligence and decision making. It concludes with a review of data mining.

Preface	p. xvii
Acknowledgments	p. xxv
1 Introduction to Database Systems	p. 1
Objectives	p. 1
1.1 Functions of a Database	p. 1
1.2 Database Management System	p. 2
1.3 Database Components	p. 8
1.4 Database Development Process	p. 14
1.5 Summary	p. 15
Review Questions	p. 16
2 Conceptual Design and Data Modeling	p. 17
Objectives	p. 17
2.1 Introduction to Database Design Process	p. 17
2.1.1 Conceptual Design	p. 18
2.1.2 Database Design	p. 18
2.1.3 Physical Design	p. 18
2.2 Understanding Business Process	p. 19
2.2.1 Business Process	p. 19
2.2.2 Investigating Business Requirements	p. 21
2.3 Entity-Relationship Data Model	p. 24
2.3.1 Entities	p. 25
2.3.2 Attributes, Identifiers, and Domains	p. 25
2.3.3 Relationships	p. 26
2.3.4 Cardinality	p. 30
2.3.5 Relationship Naming	p. 31
2.3.6 Recursive Relationships	p. 32
2.3.7 Ternary Relationships	p. 33
2.3.8 Business Rules	p. 34
2.4 Representing Business Process with Entity-Relationship Model	p. 35
2.4.1 Determining Entities from Business Information	p. 35
2.4.2 Identifying Attributes from Business Information	p. 36
2.4.3 Identifying Relationships among Entities	p. 39
2.4.4 Identifying Cardinalities	p. 40
2.4.5 Creating Entity-Relationship Diagrams	p. 43
2.4.6 Entity-Relationship Modeling	p. 50
2.5 Summary	p. 52
Review Questions	p. 52
Case Study Projects	p. 53
1 Computer Service	p. 53
2 University Registration	p. 54
3 Mail Order	p. 54
3 Table Structure and Normalization	p. 57
Objectives	p. 57
3.1 Introduction to Tables	p. 57
3.1.1 Tables	p. 57
3.1.2 Keys	p. 58
3.1.3 Linking Tables	p. 60
3.1.4 Functional Dependency	p. 60
3.2 Table Normalization	p. 62
3.2.1 Why Table Normalization	p. 62
3.2.2 Normal Forms	p. 66
3.3 Summary	p. 83
Review Questions	p. 84
Case Study Projects	p. 84
1 Computer Service	p. 85
2 University Registration	p. 85
3 Mail Order	p. 85
4 Transforming Data Models to Relational Databases	p. 87
Objectives	p. 87
4.1 Introduction	p. 87
4.2 DBMS Selection	p. 88
4.3 Transforming Data Models to Relational Databases	p. 89
4.3.1 Representing Entities	p. 89
4.3.2 Representing Relationships	p. 93
4.4 Enforcing Constraints	p. 102
4.5 Creating Database for Business Process	p. 104
4.5.1 Creating the Hillcrest Computing Database	p. 110
4.5.2 Designing Tables	p. 111
4.5.3 Creating Surrogate Keys	p. 113
4.5.4 Enforcing Constraints	p. 115
4.5.5 Creating Relationship Diagrams	p. 118
4.6 Summary	p. 121
Review Questions	p. 121
Case Study Projects	p. 122
1 Computer Service	p. 122
2 University Registration	p. 122
3 Mail Order	p. 122
5 Physical Design and Database Implementation with SQL	p. 123
Objectives	p. 123
5.1 Introduction	p. 123
5.2 Physical Design	p. 124
5.2.1 Database System Architecture	p. 124
5.2.2 Data Type and Size	p. 124
5.2.3 Database Accessing	p. 125
5.2.4 Data Usage	p. 125
5.3 Creating, Controlling, and Modifying Database Objects with SQL	p. 125
5.3.1 Creating Database Objects	p. 126
5.3.2 Modifying Database Objects	p. 136
5.3.3 Manipulating Data in Tables	p. 140
5.3.4 Controlling Database Object Privileges	p. 141
5.4 Transporting Database Data	p. 142
5.4.1 Entering Data Manually	p. 142
5.4.2 Importing and Exporting Data	p. 143
5.4.3 Accessing External Data	p. 149
5.4.4 Copying Database	p. 152
5.5 Summary	p. 154
Review Questions	p. 154
Case Study Projects	p. 156
1 Computer Service	p. 156
2 University Registration	p. 157
3 Mail Order	p. 157
6 Querying Databases	p. 159
Objectives	p. 159
6.1 Introduction	p. 159
6.2 Retrieving Data from Tables	p. 159
6.2.1 Querying with SELECT, FROM and WHERE Statements	p. 160
6.2.2 Subqueries	p. 169
6.2.3 Joining Multiple Tables with SQL	p. 172
6.2.4 SQL Built-In Functions	p. 179
6.3 Summary	p. 181
Review Questions	p. 182
Case Study Projects	p. 183
1 Computer Service	p. 183
2 University Registration	p. 183
3 Mail Order	p. 184
7 SQL Procedures	p. 185
Objectives	p. 185
7.1 Introduction	p. 185
7.2 SQL Programming Extension	p. 186
7.2.1 Variables	p. 186
7.2.2 Flow-Control Structures	p. 187
7.3 Procedures and Functions	p. 190
7.3.1 Functions	p. 190
7.3.2 Procedures	p. 196
7.4 Triggers	p. 202
7.4.1 About Triggers	p. 203
7.4.2 Using Triggers	p. 206
7.5 Debugging SQL Procedures	p. 210
7.5.1 Procedure Debugger	p. 211
7.5.2 RETURN Statement	p. 213
7.5.3 @@ERROR	p. 215
7.5.4 RAISERROR	p. 216
7.6 Summary	p. 217
Review Questions	p. 217
Case Study Projects	p. 218
1 Computer Service	p. 218
2 University Registration	p. 219
3 Mail Order	p. 219
8 Database Views, Indexes, and Cursors	p. 221
Objectives	p. 221
8.1 Introduction	p. 221
8.2 Creating and Managing Views	p. 225
8.2.1 Creating Views	p. 225
8.2.2 Modifying Views	p. 229
8.2.3 Modifying Data in Views	p. 230
8.2.4 Creating Calculated Columns in Views	p. 230
8.2.5 Deleting Views	p. 233
8.3 Creating and Managing Indexes	p. 233
8.3.1 Creating Indexes	p. 234
8.3.2 Managing Indexes	p. 236
8.4 Creating and Managing Cursors	p. 239
8.4.1 Client Cursors	p. 240
8.4.2 Application Programming Interface (API) Server Cursors	p. 240
8.4.3 Transact-SQL Cursors	p. 241
8.5 Case Study: Hillcrest Computing	p. 242
8.6 Summary	p. 253
Review Questions	p. 253
Case Study Projects	p. 254
1 Computer Service	p. 254
2 University Registration	p. 254
3 Mail Order	p. 255
9 Accessing Data	p. 257
Objectives	p. 257
9.1 Introduction	p. 257
9.2 Database Accessing	p. 258
9.3 Open Database Connectivity (ODBC)	p. 260
9.4 Object Linking and Embedding Database (OLE DB)	p. 266
9.5 Active Data Object (ADO)	p. 269
9.5.1 Example: Creating an ADO RecordSet Object	p. 279
9.6 Summary	p. 283
Review Questions	p. 283
Case Study Projects	p. 284
1 Computer Service	p. 284
2 University Registration	p. 284
3 Mail Order	p. 285
10 Database Application Development	p. 287
Objectives	p. 287
10.1 Introduction	p. 287
10.2 Understanding Business Process	p. 288
10.3 User Interface Design and Format	p. 290
10.3.1 Graphical User Interface	p. 290
10.3.2 Enforcing Cardinality Constraints	p. 293
10.4 Creating Forms	p. 296
10.4.1 Creating Forms with Form Wizard	p. 297
10.4.2 Creating Forms without Wizard	p. 302
10.4.3 Creating Company Logo	p. 303
10.4.4 Creating Views for Forms	p. 305
10.4.5 Placing Controls to Forms	p. 305
10.4.6 Configuring Properties for Controls	p. 306
10.4.7 Configuring Option Group with Control Wizard	p. 308
10.4.8 Configuring Text Box with Conditional Formatting	p. 309
10.4.9 Programming Event Procedures	p. 312
10.4.10 Configuring Click Event for Combo Box	p. 312
10.4.11 Creating Subforms	p. 314
10.4.12 Creating Subform with Wizard	p. 315
10.4.13 Configuring Click Event for Command Button	p. 318
10.4.14 Configuring Command Button Using Wizard	p. 321
10.5 Creating Reports	p. 323
10.5.1 Creating Reports Using Wizards	p. 323
10.5.2 Creating Comprehensive Reports Using Forms, Reports, and Graphics	p. 328
10.6 Summary	p. 335
Review Questions	p. 336
Case Study Projects	p. 336
1 Computer Service	p. 337
2 University Registration	p. 337
3 Mail Order	p. 337
11 Network Databases	p. 339
Objectives	p. 339
11.1 Introduction	p. 339
11.2 Client/Server Computing	p. 340
11.2.1 Two-Tier Architecture	p. 341
11.2.2 Three-Tier Architecture	p. 342
11.3 Introduction to Extehsible Markup Language (XML)	p. 344
11.3.1 XML Data File (.xml File)	p. 346
11.3.2 XML Schema Definition Language File (.xsd File)	p. 347
11.3.3 Extensible Stylesheet File (.xsl file)	p. 350
11.3.4 Export/Import XML Data	p. 353
11.4 Developing Database Applications with Visual Studio .NET	p. 356
11.4.1 Developing Windows Application	p. 357
11.4.2 Developing Web Application	p. 372
11.5 XML Web Services and InfoPath	p. 384
11.5.1 Creating Web Services with Visual Studio .NET	p. 385
11.5.2 Creating InfoPath Forms	p. 391
11.6 Summary	p. 405
Review Questions	p. 407
Case Study Projects	p. 407
1 Computer Service	p. 407
2 University Registration	p. 408
3 Mail Order	p. 409
12 Database Administration	p. 411
Objectives	p. 411
12.1 Introduction	p. 411
12.2 Managing Database User Accounts and Security	p. 412
12.2.1 Server Authentication	p. 412
12.2.2 Server Authorization	p. 414
12.2.3 Creating Roles and Users, and Auditing Log-Ins	p. 417
12.3 Backing Up and Recovering Databases	p. 424
12.3.1 About Database Backups	p. 426
12.3.2 About Database Recovery	p. 429
12.3.3 Configuring Recovery Model	p. 431
12.3.4 Creating Backup Device	p. 431
12.3.5 Backing Up Database	p. 432
12.3.6 Restoring Database	p. 435
12.4 Database Replication	p. 437
12.4.1 Creating Distribution Database	p. 438
12.4.2 Configuring Replication Publisher	p. 439
12.4.3 Configuring Replication Subscriber	p. 440
12.5 Optimizing Database Performance	p. 442
12.5.1 Transactions and Locks	p. 443
12.5.2 Tools Used in Performance Tuning	p. 445
12.5.3 Impact of Database Structure on Performance	p. 456
12.6 Database Maintenance Plan	p. 459
12.7 Summary	p. 462
Review Questions	p. 463
Case Study Projects	p. 463
1 Computer Service	p. 463
2 University Registration	p. 464
3 Mail Order	p. 464
13 Data Analysis Services	p. 465
Objectives	p. 465
13.1 Introduction	p. 465
13.2 Data Warehouse	p. 467
13.2.1 Data Warehouse Components	p. 468
13.2.2 Data Warehouse Developing Tools	p. 469
13.2.3 Data Warehouse Design	p. 470
13.2.4 Data Transformation	p. 474
13.3 OnLine Analytical Processing (OLAP)	p. 486
13.3.1 OLAP Terminology	p. 487
13.3.2 OLAP Architecture	p. 489
13.3.3 Analysis Manager	p. 491
13.3.4 PivotTable Service	p. 500
13.4 Summary	p. 508
Review Questions	p. 510
Case Study Projects	p. 511
14 Data Mining	p. 513
Objectives	p. 513
14.1 Introduction	p. 513
14.2 Data-Mining Process	p. 515
14.2.1 Data-Mining Process Standards	p. 515
14.3 Data-Mining Algorithms	p. 523
14.3.1 Decision Tree Algorithm	p. 524
14.3.2 Clustering Algorithm	p. 531
14.4 Developing Data-Mining Models in SQL Server	p. 535
14.4.1 Preparing Data-Mining Tools in Analysis Services	p. 535
14.4.2 Using Data Transformation Services to Prepare Data for Data Mining	p. 536
14.4.3 Exploring Relationships between Predictable Columns and Input Columns	p. 539
14.4.4 Creating Decision Tree Data-Mining Model Using Single Relational Table	p. 544
14.4.5 Creating Cluster Data-Mining Models	p. 547
14.4.6 Deploying Data-Mining Results with DTS	p. 555
14.5 Summary	p. 564
Review Questions	p. 565
Case Study Projects	p. 566
Appendices
Appendix A Sample Databases	p. 567
A.1 Student_Club Database	p. 567
A.2 Hillcrest Computing Database	p. 575
Appendix B Installation of SQL Server	p. 585
SQL Server Installation	p. 585
Appendix C Suggested Resources	p. 591
Web Sites	p. 591
Books and Articles	p. 592
Index	p. 595

Available:*

On Order

Summary

Summary

Table of Contents