Unformatted text preview: which has a CO_PI investigator. g CO_PI& is a value of the E Inv_role& attribute in the works_on table. 6)Retrieve all the projects (project id, project title) in which ± John Smith( serves as a principle investigator. Prof. JIN create table contact_remainder(Contact_ID varchar(20), Project_ID varchar(20), Contact_Remainders varchar(20), primary key(Contact_ID, Project_ID, Contact_Remainders)) alter table contact_remainder add foreign key (Contact_ID, Project_ID) references Contact_History(Contact_ID,Project_ID)...
View Full Document
This note was uploaded on 10/26/2009 for the course CSC CSC 134 taught by Professor Jinyin during the Spring '09 term at CSU Sacramento.
- Spring '09