This preview shows page 1. Sign up to view the full content.
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
- Spring '09