Creating the data source

Again, the database will have a very simple schema. The schema will contain:

A unique identifier
A Last name
A First name
A Phone number

The unique identifier will serve as the primary key for the database queries. Below is an example of this schema from SQL Server 2000.

SQL Server 2000 database schema

CREATE TABLE [dbo].[Employees] (
[id] [int] IDENTITY (1, 1) NOT NULL, 
[lastname] [varchar] (50) COLLATE 
    SQL_Latin1_General_CP1_CI_AS NOT NULL, 
[firstname] [varchar] (50) COLLATE 
    SQL_Latin1_General_CP1_CI_AS NULL, 
[phonenumber] [varchar] (50) COLLATE 
    SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]

Send feedback about this page using email.