DA261 – Third deliverable – Journey College Internship- Screenshots&statement attached-A+ solution

Part 3:

1.
In the table named Internship (that has already been created), fill in the table using anything we want. It looks like you started this, just need to complete all fields.
2.
Create a Student Internship table with the following fields:
SSN , Internship ID, Year, Term
SSN is social security number.
Year is 1999,2000,2001,2002,2003, etc…..
Term is Fall, Spring, Summer.
So, you just have to modify your existing table it looks like.
3.
This query will more or less connect the needed tables:
SELECT SSN, Internship.InternshipID, Year, Term, Agency Name, Title, Description of Duties
FROM Student Internship, Internship, Agency
WHERE StudentInternship.InternshipID = Internship.InternshipID AND Internship.Agency = Agency.AgencyID
4.
Change Password to DA261 on VB Switchboard
5.
Any other clean-up of forms, etc. Making it look uniform and “pretty” / “professional”.