计算机科学与技术：VB.NET应用教程 教学课件 作者 978 7 302 09622 1 Advanced VB.NET Chapter 9.pptVIP

Copyright 2004 Pearson Education, Inc. Chapter 9 Overview of Database Programming Objectives Database, Tables, Tuples, and Attributes Indexes and Keys Relationships An Overview of ADO.NET Connecting to SQL Server Connecting to Access Accessing a Database with Data Controls The Connection Class Lab 9: The Data Adapter and Data Binding Suggested Home Assignments Database A software package that manages the data. Data is accessible only through the DBMS. Controls access to the data. Handles data integrity. Handles concurrency control. Manages data definition. In relational databases the interface is through Structured Query Language also called SQL. Database Services Tables A Relational Database Manages data in a set of interrelated Tables. Each table handles one entity or one relationship between two entities. Tables, Tuples, and Attributes A Table represents an Entities Type (typically a noun): Library. Books. Patrons. Or a Relationship Type (typically a verb): Patron Borrows Books. Patron Returns Books. Books reside in Library. Tables, Tuples, and Attributes A Table represents an Entities or a Relationship Type Think of this as a Class. Each Row (Tuple) is one instance of the entity or the relationship. Think of this as an instantiated object. Within each Row, each column is an attribute An Attribute is one data item about the specific entity. Name Address Age Database: A Collection of Tables Tables Defining Tables in Access Discussion A database is an object. It is also managed as such in VB. What are the advantages and why is it necessary to treat databases this way. Objectives Database, Tables, Tuples, and Attributes Indexes and Keys Relationships An Overview of ADO.NET Connecting to SQL Server Connecting to Access Accessing a Database with Data Controls The Connection Class Lab 9: The Data Adapter and Data Binding Suggested Home Assignments Indexes An Index, A separate file used to enable faster retrieval from a data table. Each entry in the index points to a