Use Master
/*check to see if the database exists */
if exists
	(Select [name] from sys.databases
	  where [name]='CommunityAssist')
Begin
	  Drop database CommunityAssist
	 
End
/*create database */
Create database CommunityAssist
Go
/*Use the database and create tables */
Use CommunityAssist
GO
Create table Person
(
  PersonKey int identity(1,1)Primary Key,
  LastName nvarchar(255) not null,
  FirstName nvarchar(255)
)
Go
Create table PersonAddress
(
	PersonAddressKey int identity(1,1) primary key,
	Street nvarchar(255),
	Apartment nvarchar(255) null,
	State nvarchar(2),
	City nvarchar(255),
	Zip nvarchar(10),
	PersonKey int foreign key references Person(PersonKey)
)
Go
Create table ContactType
(
	ContactTypeKey int identity(1,1) primary key,
	ContactTypeName nvarchar(255)
)

Go

Create table PersonContact
(
	ContactKey int identity(1,1) primary key,
	ContactInfo nvarchar(255),
	PersonKey int foreign key references Person(PersonKey),
	ContactTypeKey int foreign key references ContactType(ContactTypeKey)
)
Go
Create table Employee
(
	EmployeeKey int identity(1,1) primary key,
	HireDate Datetime,
	SSNumber nvarchar(9),
	Dependents int,
	PersonKey int Foreign key references Person(PersonKey)
)
Go
Create table Donation
(
	DonationKey int identity(1,1) primary key,
	DonationDate Datetime,
	DonationAmount money,
	PersonKey int foreign key references Person(PersonKey),
	EmployeeKey int foreign key references Employee(EmployeeKey)
)
GO
Create table Service
(
	ServiceKey int identity(1,1) primary key,
	ServiceName Nvarchar(255),
	ServiceDescription Nvarchar(255)
)
Go
Create table ServiceGrant
(
	GrantKey int identity(1,1) primary key,
	GrantAmount money,
	GrantDate datetime,
	PersonKey int foreign key references Person(personKey),
	ServiceKey int foreign key references Service(ServiceKey),
	EmployeeKey int Foreign key references Employee(EmployeeKey)
)	  
/*Inserts into the tables*/	 
/*Insert into Person */
Insert into Person (LastName, FirstName)
Values ('Anderson', 'Jay')
Insert into Person (LastName, FirstName)
Values ('Zimmerman', 'Toby')
Insert into Person (LastName, FirstName)
Values ('Mann', 'Louis')
Insert into Person (LastName, FirstName)
Values ('Carmel', 'Bob')
Insert into Person (LastName, FirstName)
Values ('Lewis', 'Mary')
Insert into Person (LastName, FirstName)
Values ('Tanner', 'Thomas')
Insert into Person (LastName, FirstName)
Values ('Patterson', 'Jody')
Insert into Person (LastName, FirstName)
Values ('Brown', 'Matt')
Insert into Person (LastName, FirstName)
Values ('Smith', 'Jerry')
Insert into Person (LastName, FirstName)
Values ('Peters', 'Jay')
Insert into Person (LastName, FirstName)
Values ('Masters', 'Fae')
Insert into Person (LastName, FirstName)
Values ('Moon', 'Tina')
Insert into Person (LastName, FirstName)
Values ('Nguyen', 'Lu')
Insert into Person (LastName, FirstName)
Values ('Chau', 'Mary')
Insert into Person (LastName, FirstName)
Values ('Kerry', 'Anne')
Insert into Person (LastName, FirstName)
Values ('Robinson', 'Mike')
Insert into Person (LastName, FirstName)
Values ('Martin', 'Taylor')
Insert into Person (LastName, FirstName)
Values ('McGraw', 'Alysson')
Insert into Person (LastName, FirstName)
Values ('Morgan', 'Cheryl')
Insert into Person (LastName, FirstName)
Values ('Tan', 'Lee')
Insert into Person (LastName, FirstName)
Values ('Jameson', 'Roberto')
Insert into Person (LastName, FirstName)
Values ('Banner', 'June')
Insert into Person (LastName, FirstName)
Values ('Lee', 'Tracy')
Insert into Person (LastName, FirstName)
Values ('Fabre', 'Jill')
Insert into Person (LastName, FirstName)
Values ('Gardner', 'Tom')
Insert into Person (LastName, FirstName)
Values ('Yesler', 'Bill')
Insert into Person (LastName, FirstName)
Values ('Caroll', 'Lisa')
Insert into Person (LastName, FirstName)
Values ('Lamont', 'Tess')
Insert into Person (LastName, FirstName)
Values ('Johnston', 'Sara')
Insert into Person (LastName, FirstName)
Values ('Eliot', 'James')
Insert into Person (LastName, FirstName)
Values ('Nguyen', 'Jane')
Insert into Person (LastName, FirstName)
Values ('Perry', 'Lee')
Insert into Person (LastName, FirstName)
Values ('Norton', 'Carrie')
Insert into Person (LastName, FirstName)
Values ('Farris', 'Mark')
Insert into Person (LastName, FirstName)
Values ('Farmer', 'Tim')
Insert into Person (LastName, FirstName)
Values ('Sanders', 'Lea')
Insert into Person (LastName, FirstName)
Values ('Smith', 'Jim')
Insert into Person (LastName, FirstName)
Values ('Zukof', 'Petra')
Insert into Person (LastName, FirstName)
Values ('Kim', 'Karen')
Insert into Person (LastName, FirstName)
Values ('Norman', 'Tina')
Insert into Person (LastName, FirstName)
Values ('Manning', 'Carol')
Insert into Person (LastName, FirstName)
Values ('Patton', 'Laura')
Insert into Person (LastName, FirstName)
Values ('Jorgenson', 'Amy')
Insert into Person (LastName, FirstName)
Values ('Schneider', 'Franz')
Insert into Person (LastName, FirstName)
Values ('Kim', 'Lee')
Insert into Person (LastName, FirstName)
Values ('Denny', 'Phil')
Insert into Person (LastName, FirstName)
Values ('Conner', 'Jessie')
Insert into Person (LastName, FirstName)
Values ('Keanne', 'Ann')
Insert into Person (LastName, FirstName)
Values ('Meuller', 'John')
Insert into Person (LastName, FirstName)
Values ('Rogers', 'Cherise')
Insert into Person (LastName, FirstName)
Values ('Ponge', 'Sue')

/*Inserts for Service*/
Insert into [Service] (ServiceName, ServiceDescription)
Values('Food', 'assistance for purchasing groceries')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Rent', 'assistance for monthly Rent payments')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Child care', 'assistance for childcare expenses')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Transportation', 'assistance for transportation to and from work')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Medical', 'assistance with medical bills')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Dental', 'assistance with dental bills')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Utilities', 'help with monthly utilites')
Insert into [Service] (ServiceName, ServiceDescription)
Values('home repair', 'one time assistance with home repair')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Education', 'help with worker retraining')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Clothes', 'help especially with cothes for job search or work clothes')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Funerary', 'assistence for funeral costs')
Insert into [Service] (ServiceName, ServiceDescription)
Values('holiday', 'holiday assistance (food, gifts, etc)')
Insert into [Service] (ServiceName, ServiceDescription)
Values('Emergancy Travel', 'assistance for emergancy travel needs')

/*Inserts into employee*/
Insert into Employee(HireDate, SSNumber, Dependents, PersonKey)
Values('2/21/2001','555551234',2,5)
Insert into Employee(HireDate, SSNumber, Dependents, PersonKey)
Values('5/5/2002','555553456',null,12)
Insert into Employee(HireDate, SSNumber, Dependents, PersonKey)
Values('3/10/2003','555554567',null,18)
Insert into Employee(HireDate, SSNumber, Dependents, PersonKey)
Values('3/10/2003','555555678',1,23)
Insert into Employee(HireDate, SSNumber, Dependents, PersonKey)
Values('1/15/2008','555557890',3,47)
Insert into Employee(HireDate, SSNumber, Dependents, PersonKey)
Values('4/21/2009','555550123',null,7)

/*Inserts into donations*/
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('2/2/2010',500.00,3,2)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('2/2/2010',250.00,6,1)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('2/2/2010',50.00,8,6)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('2/5/2010',1500.00,11,4)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('2/10/2010',25.00,13,2)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('2/12/2010',100.00,15,1)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('2/18/2010',500.00,19,6)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('3/2/2010',1200.00,26,5)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('3/12/2010',2500.00,28,1)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('3/15/2010',500.00,3,2)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('3/15/2010',100.00,29,3)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('3/20/2010',5000.00,31,1)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('3/25/2010',50.00,33,2)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('4/10/2010',100.00,35,4)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('4/15/2010',500.00,38,5)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('4/15/2010',2500.00,40,5)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('4/20/2010',1500.00,41,1)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('4/22/2010',50.00,42,2)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('4/25/2010',250.00,48,6)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('4/28/2010',150.00,50,1)
Insert into Donation(DonationDate, DonationAmount, PersonKey, EmployeeKey)
Values('4/30/2010',500.00,3,2)




/*inserts for ServiceGrant*/
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'2/10/2010',4,1,2)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(180.00,'2/13/2010',14,3,2)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(300.00,'2/13/2010',27,7,2)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'2/14/2010',9,1,1)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(200.00,'2/18/2010',39,10,3)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'2/19/2010',25,1,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(500.00,'2/21/2010',25,8,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(100.00,'2/25/2010',1,4,6)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'2/19/2010',1,1,6)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(800.00,'3/1/2010',16,2,5)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(600.00,'3/1/2010',20,1,5)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'3/5/2010',25,1,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'3/10/2010',39,1,3)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(475.00,'3/19/2010',17,6,1)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(100.00,'3/19/2010',49,10,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(133.00,'3/25/2010',45,7,3)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(500.00,'3/28/2010',37,9,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'3/29/2010',34,1,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(850.00,'4/1/2010',34,2,5)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(500.00,'4/1/2010',16,2,5)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'4/2/2010',25,1,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'4/9/2010',27,1,1)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(200.00,'4/10/2010',27,3,2)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(500.00,'4/15/2010',21,9,3)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(197.00,'4/19/2010',9,7,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(75.00,'4/22/2010',43,1,1)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(475.00,'4/23/2010',24,8,2)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(250.00,'4/25/2010',22,3,2)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(1200.00,'2/1/2010',45,2,5)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(1200.00,'3/19/2010',46,9,3)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(400.00,'3/29/2010',39,5,4)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(175.00,'3/29/2010',32,10,2)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(367.00,'4/10/2010',26,8,3)
Insert into ServiceGrant(GrantAmount, GrantDate, PersonKey, ServiceKey, EmployeeKey)
Values(475.00,'4/19/2010',36,6,1)

/*inserts into contactType*/
Insert into ContactType(ContactTypeName)
Values('Home Phone')
Insert into ContactType(ContactTypeName)
Values('Work Phone')
Insert into ContactType(ContactTypeName)
Values('Cell Phone')
Insert into ContactType(ContactTypeName)
Values('pager')
Insert into ContactType(ContactTypeName)
Values('fax')
Insert into ContactType(ContactTypeName)
Values('email')

/*Insert for contacts*/
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065551234',1,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065552345',2,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('3605551234',2,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065551356',3,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('lmann@mannco.com',3,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065555678',4,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065556789',5,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550001',5,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('mlewis@communityassist.org',5,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065559876',6,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065553344',6,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('tt36@gmail.com',6,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065558642',7,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550002',7,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('jpatterson@communityassist.org',7,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('mBrown@hotmail.com',8,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550875',9,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065556767',10,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065552323',11,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065551111',11,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('themaster@yahoo.com',11,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065559965',12,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550003',12,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('tmoon@communityassist.org',12,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('4155551234',13,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('4155550001',13,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('4155551469',13,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550192',14,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065557777',15,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('36065551234',16,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065552121',17,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550747',18,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550004',18,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('amcgraw@communityassist.org',18,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065558888',18,4)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('4155551200',19,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('mrob@hotmail.com',19,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065557089',20,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065552543',21,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065558697',22,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065551666',23,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550005',23,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('tlee@communityassist.org',23,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550019',23,4)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('3605552374',24,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065552019',25,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065558734',26,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065559532',27,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065551002',27,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('4155551987',28,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065551003',29,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('saraj@gmail.com',29,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065554710',30,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('ej@eliotjames.com',30,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065553478',31,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('leeperry@saturnco.com',31,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('3065551277',32,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('3065551008',32,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065557102',33,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065559381',34,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065556842',35,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065557046',36,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('leasander@msn.com',36,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550065',37,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065559603',38,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('4255551234',39,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065551113',40,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065552224',41,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('cmanning@yahoo.com',41,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065552354',42,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('3605558886',43,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('aj@morganbrothers.com',43,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065555060',44,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550033',45,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('kimlee@starbuckscoffee.com',45,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550853',46,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('phd@freemail.com',46,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550706',47,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('4235551423',48,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065550006',48,2)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('akeane@communityassist.org',48,6)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065557543',49,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065558206',50,1)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('2065557102',51,3)
Insert into PersonContact(ContactInfo, PersonKey, ContactTypeKey)
values('ponge@gmail.com',51,6)

/*Inserts for PersonAddress */
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('100 South Mann Street',null,'WA','Seattle','98001',1)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('328 Norh Division Blvd','205A','WA','Seattle','98001',2)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('110 4th Avenue','Suite 756','WA','Seattle','98002',3)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('230 Eastland Street',null,'WA','Seattle','98001',3)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('213 Elm Street',null,'WA','Seattle','98001',4)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('222 Jackson Way','201','WA','Seattle','98002',5)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('132 Second Avenue','Suite 344','WA','Seattle','98010',6)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('932 Maple Ave',null,'WA','Seattle','98001',7)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('1928 Bradly',null,'WA','Seattle','98002',8)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('7070 Westlake Ave','314','WA','Seattle','98001',9)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('Western Towers','Suite 2003','WA','Seattle','98010',10)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('100 Madison','Apt 905','WA','Seattle','98010',10)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('201A Birch',null,'WA','Seattle','98001',11)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('1325 Backway Park Road',null,'WA','Seattle','98001',12)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('100 Main',null,'WA','Kent','98011',13)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('1212 Native Street','110','WA','Seattle','98001',14)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('400 West Bank Road',null,'WA','Seattle','98001',15)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('1000 Forest Lane',null,'WA','Bellevue','98012',16)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('930 A Street',null,'WA','Seattle','98002',17)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('3030 Belle','720','WA','Seattle','98001',18)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('23 W. Century Way',null,'WA','Shoreline','98013',19)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('909 Waterview Way',null,'WA','Seattle','98002',20)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('200 Division South','101','WA','Seattle','98001',21)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('503 Route 20',null,'WA','Seattle','98010',22)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('100 12th Avenue',null,'WA','Seattle','98001',23)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('365 3rd Avenue South','213','WA','Seattle','98001',24)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('99 C Street',null,'WA','Seattle','98001',25)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('233 Kelso Road',null,'WA','Seattle','98010',26)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('200 Lakeside Plaza','1200','WA','Seattle','98010',27)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('22 Jackson Way','Rm 202','WA','Seattle','98002',27)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('3400 Candlestick blvd',null,'WA','Kent','98012',28)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('922 Hillstone way',null,'WA','Seattle','98002',29)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('1112 Nelson Blvd',null,'WA','Seattle','98002',30)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('3400 Candlestick blvd',null,'WA','Seattle','98002',31)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('22 D Street','322','WA','Kent','98002',32)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('200 Harvard',null,'WA','Shoreline','98011',33)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('1020 Smith Bld','Suite 222','WA','Seattle','98001',34)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('900 West Lake',null,'WA','Seattle','98002',34)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('101 Fourth','523','WA','Seattle','98002',35)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('1200 Wilson Road',null,'WA','Seattle','98002',36)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('3030 Lester',null,'WA','Seattle','98002',37)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('300 Brown','300','WA','Seattle','98002',38)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('400 G Street',null,'WA','Shoreline','98011',39)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('5667 Patterson','103','WA','Seattle','98001',40)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('9732 Denny',null,'WA','Seattle','98001',41)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('300 8th',null,'WA','Seattle','98001',42)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('278 Mall Way','Suite 200','WA','Bellevue','98013',43)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('78 Yale Blvd','412','WA','Seattle','98002',44)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('756 9th','Suite 200','WA','Seattle','98001',45)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('800 23rd','Suite 1200','WA','Bellevue','98013',45)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('303 Lincoln',null,'WA','Seattle','98002',46)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('879 Martin',null,'WA','Seattle','98002',47)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('900 South Broadway',null,'WA','Seattle','98001',48)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('8792 N Street',null,'WA','Seattle','98002',49)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('500 Still Street',null,'WA','Seattle','98001',50)
Insert into PersonAddress(Street, Apartment, State, City, Zip, PersonKey)
Values('900 Fifth Avenue',null,'WA','Seattle','98001',51)