Introduction Defining a Decision Support System Web-enabled Decision Support Systems Decision Support System Applications Textbook Overview Summary Exercises
4 5 7 7 9 11 12
Introduction to Databases
13
Introduction Data, Information, and Metadata File-Based Approach Database Approach Database Development Process Data Models Summary Exercises
14 15 16 18 23 25 28 29
Entity-Relationship Modeling
33
Introduction The Entity-Relationship Model Entity Attributes
Relationships Degree of a Relationship Cardinality of a Relationship Unary Relationship Binary Relationship Ternary Relationships Attributes of Relationships Associative Entities Weak Entity Types Enhanced Entity-Relationship Modeling Superclass, Subclass, and Relationships Generalization and Specialization Process Participation and Disjoint Constraints Superclass/Subclass Hierarchy Case Study: Conceptual Design for University Database In-Class Assignment Summary Exercises
Introduction The Relational Data Model Relational Keys Relational Data Integrity Constraints Transforming E-R Diagrams into Relational Schemas Case Study: Logical Design for a University Database Introduction to Normalization Data Redundancy Database Anomalies Functional Dependencies Forms of Normalization In-Class Assignment Summary Exercises
Introduction Hands-On Tutorial: Creating Access Tables in the Datasheet View Hands-On Tutorial: Creating Access Tables in the Design View Field Data Types Field Properties The Lookup Wizard Defining a Primary Key Creating Access Tables by Using Import Wizard Working with Table Properties In-Class Assignment Summary Exercises
150 151 153 154 155 161 164 165 166 167 167 168
Relationships: Linking Access Tables
175
Introduction Defining Relationships in the Relationships Window Types of Relationships Hands-On Tutorial: Defining Relationships in Access Working with Existing Relationships In-Class Assignment Summary Exercises
176 177 182 183 184 185 185 185
Queries: Building Application Foundations
189
Introduction Working with Select Queries Queries with Multiple Tables (The Join Operation) Working with Operators Hands-On Tutorial: A Select Query with Join of Multiple Tables Using Total Row (The GroupBy Operation) Creating Calculated Fields Parameter Queries Crosstab Queries Action Queries Update Queries Delete Queries Append Queries In-Class Assignment Summary Exercises
Introduction Types of SQL Statements The Data Definition Language (DDL) The Data Manipulation Language (DML) The SELECT Statement The INSERT Statement The DELETE Statement The UPDATE Statement Summary In-Class Assignment Exercises
Introduction Exploring Visual Studio IDE Visual Studio IDE Windows Object-Naming Conventions A Look at the VB .NET’s Code Window The Object Browser In-Class Assignment Summary Exercises
258 258 261 268 268 271 272 273 273
Visual Basic .NET Programming Language
275
Introduction Visual Basic Statements InputBox and MessageBox Visual Basic Data Types Adding Windows Forms and Setting a Start-up Form Control Structures Arithmetic, Logical, and String Operators Arrays Multi-Dimensional Arrays Dynamic Arrays Code Debugging In-Class Assignment Summary Exercises
Introduction Procedures Subroutine Procedures Function Procedures Visual Basic Modules Visual Basic Classes Navigating Through Application Forms Exception Handling In-Class Assignment Summary Exercises
322 322 324 327 331 334 337 338 343 343 344
Windows Forms and Controls
349
Introduction The Controls The Label and LinkLabel Controls The TextBox Control: In Depth The Button Control The CheckBox Control The ListBox Control: In Depth The ComboBox Control The CheckedListBox Control The DateTimePicker Control The TreeView Control Arranging Controls on a Form The Start-up Object In-Class Assignment Summary Exercises
Introduction Database Applications Overview Hands-On Tutorial: Creating a Simple Database Application Auto-Generated Objects in the Component Tray Hands-On Tutorial: Displaying Data in Individual Windows Controls Hands-On Tutorial: Binding Data to Existing Controls Hands-On Tutorial: Displaying Related Data on a Windows Form DataGridView Control Hands-On Tutorial: Creating a Search Form The Query Builder Hands-On Tutorial: Creating a Lookup Table
378 378 380 387 388 391 392 396 398 403 403
ch00_fm_4770
x
4/4/07
12:03 PM
Page x
Contents
14.12 14.13 14.14 14.15
Data Binding Properties of a ComboBox Control In-Class Assignment Summary Exercises
406 406 407 407
CHAPTER 15
Advance Topics in Database Connectivity
411
Introduction ADO .NET Architecture A Database Connection Hands-On Tutorial: Displaying Data on a Form with Multiple Parameters Hands-On Tutorial: Displaying Data on a Form from Join of Multiple Tables Hands-On Tutorial: Displaying Data Using Existing MS Access Query Hands-On Tutorial: Passing Data between Forms in a Windows Application DataSets Inserts, Updates, and Deletes in a Windows Application Hands-On Tutorial: Updating Changes to Multiple Tables in the Database In-Class Assignment Summary Exercises
Introduction Crystal Report Primer: A Simple Student Report Crystal Report Sections Customizing Reports: Exploring the Design Environment Properties of a CrystalReportViewer Control Hands-On Tutorial: Creating a Pie Chart to Display Faculty Salaries Hands-On Tutorial: Creating a Crystal Report Based on Multiple Tables Hands-On Tutorial: Creating Parameterized Crystal Reports In-Class Assignments Summary Exercises
448 449 460 461 463 464 467 472 476 476 476
Web Application Development with ASP .NET
CHAPTER 17
417
479
Web Introduction and Essential HTML
481
Introduction Internet, Web, and Related Terminologies HyperText Markup Language (HTML) Essential Text Formatting
482 482 484 487
ch00_fm_4770
4/4/07
12:03 PM
Page xi
Contents
17.5 17.6 17.7 17.8 17.9 17.10 17.11 17.12 17.13
xi
HTML Hyperlinks Page Backgrounds Adding Graphics to Web Pages Structuring Web Pages Using HTML Tables Using Visual Studio’s Design View: WYSIWYG Web Form and HTML Controls In-Class Assignments Summary Exercises
493 494 495 496 498 499 502 503 503
Introduction to ASP .NET
505 506 506 509
18.5 18.6 18.7 18.8 18.9 18.10 18.11 18.12
Introduction ASP.NET Primer: Sum of N Numbers Hands-On Tutorial: Currency Conversion Example Extending the Currency Conversion Example— The AutoPostBack Property Using the Page_Load Event and IsPostBack Property Working with the Page Directive Validation Controls Passing Parameters through URL User-Defined Controls In-Class Assignments Summary Exercises
CHAPTER 19
Database Connectivity in Web Applications
531
Introduction Connecting to the Access Database Using the Server Explorer Window Hands-On Tutorial: Displaying Data on a Web Page Reconfiguring SQL Query in an AccessDataSource Paging, Sorting, and Data Manipulation in a GridView Control Hands-On Tutorial: Displaying Data on a Web Page from a Query with a Join of Multiple Tables Hands-On Tutorial: Displaying Data-Bind Images in a GridView Control Hands-On Tutorial: Adding Lookup and Filter Functionalities to a Web Page Hands-On Tutorial: Displaying Related Data in a DetailsView Control Hands-On Tutorial: Working with the Repeater Control Web-Based Crystal Reports Programmatically Accessing the Database In-Class Assignment Summary Exercises
CASE STUDY 1 CS1.1 CS1.2 CS1.3 CS1.4 CS1.5 CS1.6 CS1.7 CS1.14 CS1.15
CASE STUDY 2 CS2.1 CS2.2 CS2.3 CS2.4 CS2.5 CS2.6 CS2.7 CS2.8 CS2.9 CS2.10 CS2.11
CASE STUDY 3 CS3.1 CS3.2 CS3.3 CS3.4 CS3.5 CS3.6 CS3.7
CASE STUDY 4 CS4.1 CS4.2 CS4.3 CS4.4 CS4.5 CS4.6 CS4.7 CS4.8 CS4.9
573
Online Book Store
575
Introduction Application Functionalities and Assumptions The Master Page The Index Page The Shopping Cart Page The Login Page The Checkout Page Summary Extensions
576 576 578 580 589 595 595 598 598
Portfolio Management and Optimization
599
Introduction Application Functionalities and Assumptions The Master Page The Index Page The Personal Information Page The Stock Comparison Page The Portal Page Portfolio Operations The Optimization Page Summary Extensions
600 600 602 604 604 606 609 610 615 620 620
Television Advertisement Allocation
621
Introduction Application Functionalities The Channel Information and Program Information Pages The Customer Preferences Form The Advertisement Allocation Page Summary Extensions
622 623 624 632 633 636 636
Voyage Prophesy
639
Introduction Application Functionalities The Startup Form, User Controls, and MapPoint Reference The Search Form The Show Map Form The DriveIt Form The Direction Form Summary Extensions
640 640 641 645 647 650 651 652 653
ch00_fm_4770
4/4/07
12:03 PM
Page xiii
Contents
CASE STUDY 5 CS5.1 CS5.2 CS5.3 CS5.4 CS5.5 CS5.6 CS5.7 CS5.8 CS5.9 CS5.10
xiii
ADO .NET and MS Excel
655
Introduction Forecasting Methods: Background and Theory Forecasting Methods: Application Functionalities and Assumptions Setting up the Parameter Input Form and the Excel Sheet The Code Behind the Parameter Input Form Dynamic Production Problem (DPP) Application DPP: Setting up the Parameter Input Form and the Excel Sheet DPP: The Code Behind the Parameter Input Form Summary Application Extensions