S iena C ollege I nternship I nformation S ystem

1. SienaCollegeInternshipInformationSystem Jeffrey Koch, Team Leader Stephen Carpe, Testing Engineer Gregory Johnson, Webmaster Daniel Mattoon, Librarian Peter Suarez, Testing Leader Matthew Yette, Chief Programmer / DBA Pipeline Industries - Detailed Design

2. Detailed Design • Introduction[Jeffrey Koch] • Testing [Peter Suarez] • MiniSpecs/Database Design [Matthew Yette] • Conclusion [Jeffrey Koch] Pipeline Industries - Detailed Design

3. Testing Objectives • Execution with intent of finding errors • Good tests have high probability of finding errors • Successful tests uncover errors Pipeline Industries - Detailed Design

4. Testing Techniques • Black Box Testing • White Box Testing • Grey Box Testing Pipeline Industries - Detailed Design

5. Procedure of Testing • Unit Testing • Integration Testing • Validation Testing • System Testing Pipeline Industries - Detailed Design

6. Test Cases Pipeline Industries - Detailed Design

7. Data Flow (Level 2) Pipeline Industries - Detailed Design

8. MiniSpecs 6. Select Internship Coordinator Menu For each available option: • 1.Select Menu Choose • 2.Direct User to Menu Selection Pipeline Industries - Detailed Design

9. Pseudocode 6. Select Internship Coordinator Menu switch (option): { case ‘Letters’: Function 6.1(); case ‘Matches’: Function 6.2(); case ‘Changes’: Function 6.3(); case ‘Requests/Report’: Function 6.4(); case ‘Send Query’: Function 6.5(); } Pipeline Industries - Detailed Design

10. MiniSpecs 6.2 Matches Sites and Students For each selection: 1.Retrieve List of available Students and Internship Sites 2.Choose Students/Site 3.If further information needed on student, Then: Query Database (Function 6.5) Else: Send Letters (Function 6.1) Change Database (Function 6.3) Pipeline Industries - Detailed Design

11. Pseudocode 6.2 Matches Site and Students Recipient selected_intern; Recipient selected_site; Select * from available_intern; Select * from available_sites;  Function upon_click() { if(available_intern) { selected_intern = available_intern; } if(available_site) { selected_site = available_site; } if(more_info) { if(available_intern) { select * from available_intern where lname = available_intern.lname; } else { select * from available_site where name = available_site.name; }  }  Function 6.1();//Letters Function 6.3();//Change database Pipeline Industries - Detailed Design

12. Entity-Relation Diagrams • Entity- An actual item such as a person, place, or form • Attributes- The characteristics of an entity • Relation-The connection between different Entities • ERD’s (Entity-Relation Diagrams) Pipeline Industries - Detailed Design

13. ERD Symbols • Entity- Box • Attributes- List • Primary Key Pipeline Industries - Detailed Design

14. ERD Symbols • Relation (diamond) • One-to-Many • Many-to-Many Pipeline Industries - Detailed Design

15. Intern-Internship Site Pipeline Industries - Detailed Design

16. Interns ·StudentID::Int ·UsergroupID::Int ·Student Password::String(10) ·Student First Name::String(15) ·Student Last Name::String(25) ·Student Middle Initial::Char ·Student Address 1::String(25) ·Student Address 2::String(25) ·Student Address 3::String(25) ·Student Address 4::String(25) ·Student City::String(25) ·Student State::String(2) ·Student Zip Code::Int ·Student Gender::Char ·Student Birthdate::Int ·Student Telephone Number::Int ·Student SSN::Int ·Student Email Address::String(35) ·Student Registration Date / Time::Date ·Student Registration IP Address::Int ·Student Semester::String(10) ·Student Prospective Year of Graduation::Int ·Student Major::String(3) ·Student Internship Major::String(3) ·Student Overall GPA::Float ·Student Major GPA::Float ·Student Internship Concentration GPA::Float ·Student Number of Credits::Int ·Student Resume URL::String(50) ·Student Accepted::Bool Pipeline Industries - Detailed Design

17. Internship • ·SiteID::Int • ·UsergroupID::Int • ·ProjectID::Int • ·Site Password::String(10) • ·Site Project Semester::String(10) • ·Site Supervisor First Name::String(15) • ·Site Supervisor Last Name::String(25) • ·Site Supervisor Job Title::String(25) • ·Site Firm Name::String(35) • ·Site Address 1::String(25) • ·Site Address 2::String(25) • ·Site Address 3::String(25) • ·Site Address 4::String(25) • ·Site City::String(25) • ·Site State::String(2) • ·Site Zip Code::Int • ·Site Telephone Number::Int • ·Site Fax Number::Int • ·Site Email Address::String(35) • ·Site Previous Intern::Int (Foreign Key References Students) • ·Site Registration Date / Time::Date • ·Site Registration IP Address::Int · Site Accepted::Bool Pipeline Industries - Detailed Design

18. Entity-Relation Diagram Pipeline Industries - Detailed Design

19. Classic Waterfall Model Pipeline Industries - Detailed Design

20. Gantt Chart Pipeline Industries - Detailed Design

21. Dates of Documents and Presentations • Acceptance Test Documents- April 23 • Presentation- April 28 Pipeline Industries - Detailed Design

22. Conclusion • Create code from prototypes • Follow through with testing of code • Acceptance Testing Presentation • Questions Pipeline Industries - Detailed Design