1 / 22

S iena C ollege I nternship I nformation S ystem

S iena C ollege I nternship I nformation S ystem. Jeffrey Koch, Team Leader Stephen Carpe, Testing Engineer Gregory Johnson, Webmaster Daniel Mattoon, Librarian Peter Suarez, Testing Leader Matthew Yette, Chief Programmer / DBA. Detailed Design. Introduction [Jeffrey Koch]

gsteve
Download Presentation

S iena C ollege I nternship I nformation S ystem

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related