#Professor Table Instance
#Pid,Lname,Fname,Rank,Research
(101,"Benson","Gary","Associate","Repetitive DNA patterns"),
(102,"Kasif","Simon","Full","Functional annotation"),
(103,"Segre","Daniel","Assistant","Metabolic flux analysis"),
(104,"Xia","Brandon","Assistant","Network analysis"),

#Department Table Instance
#Did,Name,Address,Chair (professor),
(1,"Biology","5 Cummington",103),
(2,"Bioinformatics","24 Cummington",104),
(3,"Biomedical Engineering","44 Cummington",102),
(4,"Computer Science","111 Cummington",101),

#Appointment Table Instance
#Pid (professor),Did (department),Percentage
(101,2,25),
(101,4,25),
(102,3,100),
(103,2,50),
(103,3,50),
(104,1,75),
(104,2,50),

#Project Table Instance
#Prid,Pid,Sponsor,Budget
(101,101,"NSF",250000),
(102,103,"NIH",750000),
(103,102,"NIH",35000),
(104,104,"Wellcome Trust",150000),
(105,101,"IGERT",1000000),

#CoPI Table Instance
#Prid (project),Pid (professor),
(101,103),
(102,104),
(103,101),
(101,104),