GoInterns:KevinP4

I did database analyst and design as well as helped the main student forms GUI. I created the query sql file as well as edited the internship-request.php file. INSERT INTO ORGANIZATION VALUES('', '$companyName', '$companyDescription', '$address1', '$address2','city','state','zip'); INSERT INTO CONTACTS VALUES(,,'$firstName','$lastName','$email','$phone','$ext','$fax'); INSERT INTO INTERNSHIP_OPPORTUNITY(,,'$positionTitle','$numberPositions'.'$availability','$payrate','$duration','$responsibilities','$qualifications','$instructions','$comments',curdate);

/*All the select i.* or * should be replaced with actual column names for final copy so that the ID's are not visible to the user*/

/*search by company*/ select o.name, o.address, o.city, o.state, o.zip, o.companyDescription from organization o, internship_opportunity i where 	o.organizationID = i.organizationID order by o.name asc;

/* select all internship opportunities by company*/ select i.* from internship_opportunity i where 	i.organizationID = $organizationID order by i.title asc;

/* select all internship opportunities by semester*/ select * from internship_opportunity order by semester asc, title asc;

/* select all internship opportunities by location*/ select o.city, o.state, i.* from organization o, internship_opportunity i where 	o.organizationID = i.organizationID order by o.city asc, o.state asc;

/* select all internship opportunities by location*/ select * from internship_opportunity order by payRate asc;

/* order by date internship added */ select * from internship_opportunity order by dateAdded;

/*order by major...no major in any opportunity table*/ select title, numPositionsAvailable, semester, payRate, duration, responsibilities, qualifications, instructions, dateAdded from internship_opportunity order by major;

I collaborated mostly face-to-face for P4 when Dan, Steve and myself got together to work on the project.

I used Netbeans and TextWrangler.