Database design and development : a visual approach

Library	Item Barcode	Call Number	Material Type	Item Category 1	Status
Searching... PSZ JB	30000010100577	HF5548.32 F76 2006	Open Access Book	Book	Searching... Unknown
Searching... SPACE Pulau Pinang Library	30000010088744	HF5548.32 F76 2006	Open Access Book	Book	Searching... Unknown

For students in the introductory course in database who want to learn how to design rather than just manipulate relational databases.Thenbsp;book that balances database theory, business problem solving, and hands-on-practice.nbsp; This book prepares student for the workplace without sacrificing rigorous academic theory.nbsp;

Preface	p. xv
Chapter 1 The Role of Databases in Electronic Business	p. 1
Learning Objectives	p. 1
Introduction	p. 1
Components of an Organizational System	p. 2
Network	p. 2
Hardware	p. 2
Software	p. 4
Content	p. 5
What Is a Database?	p. 8
Why Are Databases Important to Business?	p. 7
General Business Example	p. 7
E-business Example	p. 8
Organization of the Text	p. 10
Summary	p. 11
Key Terms	p. 11
Exercises	p. 12
Review	p. 12
Discuss	p. 12
Practice	p. 12
Chapter 2 Relational Theory	p. 15
Learning Objectives	p. 15
Introduction	p. 15
Relational Model	p. 16
Relational Database Management System (RDBMS)	p. 16
Database Administrator (DBA)	p. 16
Entity Relationship Diagrams	p. 16
Primary Keys	p. 18
Creating Relationships: Foreign Keys	p. 20
Data Integrity	p. 21
First Normal Form	p. 22
Types of Database Systems	p. 22
Relational Advantages	p. 24
Logical Rather Than Physical Links	p. 24
Fourth-Generation Language (4GL)	p. 24
Data Independence	p. 24
Summary	p. 25
Key Terms	p. 26
Exercises	p. 27
Review	p. 27
Discuss	p. 27
Practice	p. 27
References	p. 27
Chapter 3 Conceptual Design	p. 29
Learning Obejectives	p. 29
Introduction	p. 29
Step 1 Represent Entities as Tables	p. 29
Step 2 Determine Relationships	p. 30
Step 3 List Fields	p. 30
Step 4 Identify Keys	p. 30
Step 5 Determining Data Types	p. 31
Designing a Single-Table Database	p. 31
Problem Statement	p. 31
Process	p. 32
Designing a Database with a One-to-Many Relationship	p. 33
Problem Statement	p. 33
Process	p. 33
Database with Many-to-Many Relationships	p. 36
Problem Statement	p. 36
Other Multitable Database Examples	p. 42
The Hospital Database	p. 43
The ACME Database	p. 48
The Amazon Database	p. 53
Summary	p. 60
Key Terms	p. 61
Exercises	p. 61
Review	p. 61
Discuss	p. 62
Practice	p. 62
Chapter 4 Normalization	p. 67
Learning Objectives	p. 67
Introduction	p. 67
Normal Forms	p. 68
Denormalized Designs	p. 68
Normalizing the Arcade Database	p. 68
Update Problem	p. 70
Insert Problem	p. 71
The Normal Forms	p. 72
First Normal Form (1NF)	p. 73
Determinants	p. 74
Second Normal Form (2NF)	p. 75
Third Normal Form (3NF)	p. 77
Boyce-Codd Normal Form (BCNF)	p. 80
Fourth Normal Form (4NF)	p. 83
Detecting Normalization Violations	p. 85
Summary	p. 86
Key Terms	p. 86
Exercises	p. 86
Review	p. 86
Discuss	p. 87
Practice	p. 87
Chapter 5 Advanced Database Designs	p. 89
Learning Objectives	p. 89
Introduction	p. 89
Recursive Relationships	p. 90
An Example Recursive Relationship	p. 90
Creating the Mentor Recursive Relationship	p. 91
A Many-to-Many Recursive Relationship	p. 92
Hierarchies: Supertypes and Subtypes	p. 95
A Supertype/Subtype Hierarchy Example	p. 97
A Second Supertype/Subtype Hierarchy Example	p. 100
Complex Designs	p. 101
Problem Statement: Summer Reading Fun	p. 101
Problem Statement: Swampland Real Estate	p. 107
Summary	p. 113
Key Terms	p. 114
Exercises	p. 114
Review	p. 114
Discuss	p. 115
Practice	p. 115
Chapter 6 Creating Databases with Oracle Using SQL	p. 119
Learning Objectives	p. 119
Introduction	p. 119
Physical Table Design	p. 120
Data Types and Column Widths	p. 120
The Sky Member Database	p. 120
Reserved Words	p. 121
Implementation	p. 122
The Arcade Database	p. 127
The Enrollment Database	p. 130
Creating a Concatenated Key	p. 132
Referential Integrity Controls the Order of Drop and Create	p. 132
Troubleshooting	p. 134
Invalid Identifer	p. 135
Missing or Invalid Option	p. 136
Invalid User.table.column, Table.column, or Column Specification	p. 136
Missing Expression	p. 137
Integrity Constraint Violated - Parent Key Not Found	p. 137
Summary	p. 137
Key Terms	p. 138
Exercises	p. 138
Review	p. 138
Discuss	p. 138
Practice	p. 139
Chapter 7 Retrieving Data with Oracle	p. 145
Learning Objectives	p. 145
Introduction	p. 145
Basic Retrieval Operations in SQL	p. 146
Displaying All Columns and Rows	p. 146
Using a Column List	p. 148
Sorting with Order By	p. 149
Sorting on Multiple Columns	p. 151
Selecting Rows with Where	p. 153
Where Clauses Involving Text Data	p. 155
The LIKE Operator	p. 155
Complex Where Clauses	p. 156
Multiple Conditions on the Same Column	p. 160
Using the IN Operator	p. 162
Using the BETWEEN Operator	p. 163
The NOT Operator	p. 164
Combining AND and OR	p. 165
Aggregate Functions	p. 169
The Count Function	p. 171
Using Where with Aggregate Functions	p. 172
Grouping Data in a Query	p. 174
Using DISTINCT	p. 174
Grouping and Aggregate Functions	p. 174
Limiting Groups with the Having Clause	p. 177
Combining Having and Where	p. 179
Combining Data from Different Tables	p. 181
Combining Joins with Other Where Conditions	p. 184
Joining More Than Two Tables	p. 187
Subqueries	p. 189
Summary	p. 194
Key Terms	p. 195
Exercises	p. 195
Review	p. 195
Discuss	p. 196
Practice	p. 196
Chapter 8 Creating Databases with Microsoft Access	p. 203
Learning Objectives	p. 203
Introduction	p. 203
Physical Table Design	p. 204
Data Types and Column Widths	p. 204
The Sky Member Database	p. 205
Creating an Access Database with a Single Table	p. 206
Using a Query to Display Table Data	p. 212
The Arcade Database	p. 214
Create the Database and Tables	p. 215
Create the Relationship Between the Tables	p. 215
Entering the Data for the Arcade Database	p. 217
Displaying the Data	p. 218
The Enrollment Database	p. 218
Creating the Enroll Database	p. 221
Creating a Concatenated Key	p. 221
Relationships for the Enroll Database	p. 221
Summary	p. 222
Key Terms	p. 223
Exercises	p. 223
Review	p. 223
Discuss	p. 223
Practice	p. 224
Chapter 9 Retrieving Data with Microsoft Access	p. 231
Learning Objectives	p. 231
Introduction	p. 231
Basic Retrieval Operations in SQL	p. 232
Displaying All Columns and Rows	p. 232
Using a Column List	p. 236
Sorting with Order By	p. 238
Sorting on Multiple Columns	p. 240
Selecting Rows with Where	p. 242
Where Clauses Involving Text Data	p. 244
The LIKE Operator	p. 245
Complex Where Clauses	p. 246
Multiple Conditions on the Same Column	p. 252
The NOT Operator	p. 257
Combining AND and OR	p. 258
Aggregate Functions	p. 262
The COUNT Function	p. 264
Using Where with Aggregate Functions	p. 264
Grouping Data in a Query	p. 266
Using DISTINCT	p. 266
Grouping and Aggregate Functions	p. 267
Limiting Groups with the Having Clause	p. 270
Combining Having and Where	p. 272
Combining Data from Different Tables	p. 274
Combining Joins with Other Where Conditions	p. 278
Joining More Than Two Tables	p. 280
Subqueries	p. 284
Summary	p. 289
Key Terms	p. 290
Exercises	p. 291
Review	p. 291
Discuss	p. 291
Practice	p. 292
Chapter 10 Creating Databases with Microsoft SQL Server	p. 297
Learning Objectives	p. 297
Introduction	p. 297
Physical Table Design	p. 298
Data Types and Column Widths	p. 298
The Sky Member Database	p. 300
Creating an SQL Server Database with a Single Table	p. 301
Using Query Analyzer to Insert Data	p. 311
The Arcade Database	p. 313
Create the Database and Tables	p. 314
Create the Relationship Between the Tables	p. 316
Entering the Data for the Arcade Database	p. 317
The Enrollment Database	p. 318
Creating a Concatenated Key	p. 321
Relationships for the Enroll Database	p. 321
Summary	p. 324
Key Terms	p. 325
Exercises	p. 325
Review	p. 325
Discuss	p. 325
Practice	p. 325
Chapter 11 Retrieving Data with SQL Server	p. 333
Learning Objectives	p. 333
Introduction	p. 333
Basic-Retrieval Operations in SQL	p. 334
Displaying All Columns and Rows	p. 335
The SQL Server Query Analyser	p. 337
Using a Column List	p. 338
Sorting with Order By	p. 341
Sorting on Multiple Columns	p. 344
Selecting Rows with Where	p. 346
Where Clauses Involving Text Data	p. 348
The LIKE Operator	p. 349
Where Clauses with Multiple Conditions	p. 350
Multiple Conditions on the Same Column	p. 356
Using the IN Operator	p. 359
Using the BETWEEN Operator	p. 360
The NOT Operator	p. 361
Combining AND and OR	p. 363
Aggregate Functions	p. 367
Creating Column Aliases	p. 371
Using DISTINCT	p. 373
Creating Subaggregations with Group By	p. 374
Limiting Groups with the Having Clause	p. 377
Combining Data from Different Tables	p. 379
Errors Resulting from Omitting the Join Condition	p. 382
Combining Joins with Other Where Conditions	p. 383
Joining More Than Two Tables	p. 387
Subqueries	p. 392
Summary	p. 399
Key Terms	p. 399
Exercises	p. 400
Review	p. 400
Discuss	p. 400
Practice	p. 400
Chapter 12 Accessing Databases from Web Applications with Microsoft ASP.NET	p. 407
Learning Objectives	p. 407
Introduction	p. 407
What Is ASP.NET?	p. 408
ASP.NET Web Forms	p. 408
An Example Web Application	p. 410
An Introduction to Web Developer Express	p. 410
Creating a Web Site	p. 411
Example 1 Displaying the Contents of a Table	p. 418
Creating the SqlDataSource Control	p. 419
Selecting the Data Provider	p. 420
Setting up a Data Connection	p. 421
Choosing a Connection for the Data Source	p. 422
Configuring the Data Source	p. 424
Creating a GridView Control	p. 425
Finishing the Application	p. 427
Setting Up a Connection to an Oracle Database	p. 428
Example 2 Displaying Single Records from a Table	p. 431
Creating the Web Site and Adding the Database	p. 431
Adding the Textbox	p. 433
Adding and Configuring the Data Source	p. 433
Creating the Query for the Data Source	p. 435
Setting up the Where Clause for the Query	p. 436
Adding the GridView	p. 437
Finishing the Application	p. 438
Example 3 Retrieving Data with Multiple Conditions	p. 440
Summary	p. 451
Key Terms	p. 452
Exercises	p. 453
Review	p. 453
Discuss	p. 453
Practice	p. 453
Chapter 13 Maintaining Databases from Web Applictions with Microsoft ASP.NET	p. 461
Learning Objectives	p. 461
Introduction	p. 461
The DetailsView Server Control	p. 462
Creating a Member Maintenance Web Application	p. 462
Configuring the Data Source	p. 463
Configuring the DetailsView Control	p. 465
Adding the Ability to Insert New Rows	p. 466
Adding the Ability to Update Rows	p. 474
Adding the Ability to Delete Rows	p. 477
Automatically Generating Insert, Update, and Delete Statements	p. 480
Creating a Member Maintenance Application with a GridView	p. 482
Summary	p. 485
Key Terms	p. 486
Exercises	p. 486
Review	p. 486
Discuss	p. 487
Practice	p. 487
Glossary	p. 495
Index	p. 499

Available:*

On Order

Summary

Summary

Table of Contents