BDG Scenario 1

Borrower.sql

If Exists (Select * From sysobjects Where name = N'borrower' And user_name(uid) = N'dbo')
    Drop Table dbo.borrower
Go

Create Table dbo.borrower
    (
    borrower# int Not Null Identity (1, 1),
    alias varchar(32) Not Null,
    fname varchar(64) Not Null,
    lname varchar(64) Not Null,
    location varchar(64) Null,
    phone varchar(32) Null,
    title varchar(64) Null,
    dept varchar(64) Null,
    last_cko_date datetime Null,
    n_ckos smallint Not Null Constraint DF_borrower_n_ckos Default (0),
    is_staff tinyint Not Null Constraint DF_borrower_is_staff Default (0)
    )
Go
Alter Table dbo.borrower Add Constraint
    PK_borrower Primary Key Nonclustered
    (
    borrower#
    )
Go