Add NoteAdd Note

HighlightHighlight

CopyCopy

ZoomZoom

PrintPrint

HelpHelp

PreviousPrevious

NextNext

« Back to My CourseSmart

Database Design and Development: A Visual Approach

by Raymond Frost - Ohio University; John Day - Ohio University; Craig Van Slyke - University of Central Florida

eTextbook digital rental: 180 days

Our Price: $66.99

Regular Price: $166.67

You save: $99.68

Available Online Only

Add to Cart

Free Trial

Access sample pages from your bookshelf. Take notes, highlight, print and more!

Start Free Trial

Tabs for Contents, notes, highlights

Hide Contents, Notes, and Highlights

Search TermsShow Hide

« Back to eTextbook

Copyright, ii
Preface, xv
About the Authors, xix
1. The Role of Databases in Electronic Business, 1
Learning Objectives, 1
Introduction, 1
Components of an Organizational System, 2
What Is a Database?, 6
Why Are Databases Important to Business?, 7
Organization of the Text, 10
Summary, 11
Key Terms, 11
Exercises, 12
2. Relational Theory, 15
Learning Objectives, 15
Introduction, 15
Relational Model, 16
Entity Relationship Diagrams, 16
Types of Database Systems, 22
Summary, 25
Key Terms, 26
Exercises, 27
References, 28
3. Conceptual Design, 29
Learning Objectives, 29
Introduction, 29
Designing a Single-Table Database, 31
Designing a Database with a One-to-Many Relationship, 33
Database with Many-to-Many Relationships, 36
Other Multitable Database Examples, 42
Summary, 60
Key Terms, 61
Exercises, 61
4. Normalization, 67
Learning Objectives, 67
Introduction, 67
Normal Forms, 68
Normalizing the Arcade Database, 68
The Normal Forms, 72
Summary, 86
Key Terms, 86
Exercises, 86
5. Advanced Database Designs, 89
Learning Objectives, 89
Introduction, 89
Recursive Relationships, 90
Hierarchies: Supertypes and Subtypes, 95
Complex Designs, 101
Summary, 113
Key Terms, 114
Exercises, 114
6. Creating Databases with Oracle Using SQL, 119
Learning Objectives, 119
Introduction, 119
Physical Table Design, 120
The Sky_Member Database, 120
The Arcade Database, 127
The Enrollment Database, 130
Troubleshooting, 134
Summary, 137
Key Terms, 138
Exercises, 138
7. Retrieving Data with Oracle, 145
Learning Objectives, 145
Introduction, 145
Basic Retrieval Operations in SQL, 146
Aggregate Functions, 169
Grouping Data in a Query, 174
Combining Data from Different Tables, 181
Subqueries, 189
Summary, 194
Key Terms, 195
Exercises, 195
8. Creating Databases with Microsoft Access, 203
Learning Objectives, 203
Introduction, 203
Physical Table Design, 204
The Sky_Member Database, 205
The Arcade Database, 214
The Enrollment Database, 218
Summary, 222
Key Terms, 223
Exercises, 223
9. Retrieving Data with Microsoft Access, 231
Learning Objectives, 231
Introduction, 231
Basic Retrieval Operations in SQL, 232
Aggregate Functions, 262
Grouping Data in a Query, 266
Combining Data from Different Tables, 274
Subqueries, 284
Summary, 289
Key Terms, 290
Exercises, 291
10. Creating Databases with Microsoft SQL Server, 297
Learning Objectives, 297
Introduction, 297
Physical Table Design, 298
The Sky_Member Database, 300
The Arcade Database, 313
The Enrollment Database, 318
Summary, 324
Key Terms, 325
Exercises, 325
11. Retrieving Data with SQL Server, 333
Learning Objectives, 333
Introduction, 333
Basic Retrieval Operations in SQL, 334
Displaying All Columns and Rows, 335
Aggregate Functions, 367
Combining Data from Different Tables, 379
Subqueries, 392
Summary, 399
Key Terms, 399
Exercises, 400
12. Accessing Databases from Web Applications with Microsoft ASP.NET, 407
Learning Objectives, 407
Introduction, 407
What Is ASP.NET?, 408
An Example Web Application, 410
Example 1: Displaying the Contents of a Table, 418
Example 2: Displaying Single Records from a Table, 431
Example 3: Retrieving Data with Multiple Conditions, 440
Summary, 451
Key Terms, 452
Exercises, 453
13. Maintaining Databases from Web Applications with Microsoft ASP.NET, 461
Learning Objectives, 461
Introduction, 461
The DetailsView Server Control, 462
Creating a Member Maintenance Web Application, 462
Automatically Generating Insert, Update, and Delete Statements, 480
Creating a Member Maintenance Application with a GridView, 482
Summary, 485
Key Terms, 486
Exercises, 486
Glossary, 494
Index, I-1-1

Search Results

« Back to eTextbook


PAGE	Description

7	...

Tabs for Contents, notes, highlights

Table of Contents

Search Results