/*********************
Insert for Doctor table
ITC 224:  Bi-Lan Chiong
**********************/

USE ClinicalDrugStudy

Insert into Doctor(
docLastName, 
docFirstName, 
docAddress, 
docCity, 
docState, 
docZipCode)
Values(
'Spock',
'Charles',
'925 Minor Ave, Suite 522',
'Seattle',
'WA',
'98122')

Insert into Doctor(
docLastName, 
docFirstName, 
docAddress, 
docCity, 
docState, 
docZipCode)
Values(
'Freud',
'Sigmund',
'325 Ninth Ave, Suite 201',
'Seattle',
'WA',
'98104')

Insert into Doctor(
docLastName, 
docFirstName, 
docAddress, 
docCity, 
docState, 
docZipCode)
Values(
'Seuss',
'Oscar',
'1025 Broadway, Suite 1032',
'Seattle',
'WA',
'98122')

Insert into Doctor(
docLastName, 
docFirstName, 
docAddress, 
docCity, 
docState, 
docZipCode)
Values(
'Tanaka',
'Takashi',
'725 Olive Way, Suite 2302',
'Seattle',
'WA',
'98101')

Insert into Doctor(
docLastName, 
docFirstName, 
docAddress, 
docCity, 
docState, 
docZipCode)
Values(
'Zelenkov',
'Margaret',
'1725 Jefferson St, Suite 1056',
'Seattle',
'WA',
'98122')