Visual Basic 2008 Programming: Business Applications with a Design Perspective
Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9
Chapter 10 Chapter 11 Chapter 12 Chapter 13 Chapter 14 Appendix A Appendix B Appendix C Home
Last change: February 13 2016 18:48:19.

 Chapter in PDF

Table of Contents

Chapter 9: Database and ADO.NET
Last change: February 13 2016 18:47:33.

9.1 Introduction to Database

A database is a collection of stored data that are managed by the database management system (DBMS). There are several conceptual models for the database with one being the relational database model. Under this model, a database is a collection of tables, each consisting of rows and columns. Each row represents a record, and a column represents a field, which is the smallest data element that has practical meaning. Examples of fields include the transaction date, Social Security number, and product name. This model is popular because it’s easy to understand and use. Almost all the current commercial database software packages for personal computers are built under this model. Microsoft Access, SQL Server, FoxPro, and Oracle9i are all examples of relational database software.
Last change: February 13 2016 18:47:33.
  1. 9.1 Introduction to Database
    1. Table Definitions
    2. Indexes, the Primary Key, and the Foreign Key
    3. Introduction to the SQL
    4. <<PreviousNext>>