Module 1 – SLP/PROJECT REQUIREMENTS.

Systems integration requires the blending of existing and potentially new components to create a business process solution. The SLP assignments in this course are designed to lead you through the steps required to complete a systems integration project. In this first SLP assignment you will select a project and write the requirements for the project.
Project Selection
IMPORTANT: Project selection must be completed and approved by Friday of the first week of the course. Failure to get your project approved by this due date will reduce the time you have available to complete the graded part of this SLP assignment (requirements) and will impair your progress in Module 2.
For the course project you will select a systems integration project that solves a business process problem. The business process you select will guide you through the rest of the SLP assignments so careful consideration of the project and good communication with your instructor are important at this point.
Points to consider in project selection:
•    The project must integrate new or existing systems to address a business process.
•    The project should not be too complex although it should be sufficient to allow you to demonstrate the skills you have learned in the courses taken prior to this course.
•    You should have access to any subsystems or information required to complete the project.
•    You will need to create some portion of the project (i.e., you cannot just use existing systems). At a minimum, you will need to create some portion of the system that integrates the other subsystems. Your work must include some programming (language of your choice) and the use of a database for some aspect of the project.
•    It is highly desirable to create a Web-based application for this project due to the availability of Web services that are useful for integration purposes. Web-based applications can also be operated on publicly available Web sites which will make them easier to deploy and evaluate. If you choose to create a Web-based project, be sure to check the availability of scripting, server-side coding, and database capabilities on your Web hosting server. You may not have a significant background in Web application development. Some background on Web development and Web Services was provided in the standard curriculum and examples are provided in the reading materials for this course. The type of Web application required to integrate Web Services and create and integrated system are not overly complicated and can be created in languages you are probably familiar with already (PHP, Java, C#).
For your consideration, you may wish to review material in previous courses as useful resources for your project:
•    You may go through CSC212 to demonstrate the ability to use Eclipse IDE for Java Development and touch the nature and scope of Object Oriented Programming.
•    You may go through CSC230 to learn about different search and sort algorithms, and data structures.
•    You may go through CSC310 to use some important programming topics such as error checking, file processing, database connectivity, web applications, and web services.
•    You may go through CSC316 in terms of database design in order to design the required tables, draw an Entity Relation Diagram and construct project normalized database.
•    You may go through CSC317 to understand how to use SQL statements to generate reports and use JDBC API for accessing a database from Java applications.
SLP Assignment Expectations
Project Proposal (non-graded)
•    The proposal is due by Friday of the first week of class.
•    Write a short (1- to 2-paragraph) description of the business process you want to address in the project. Include a discussion of the existing subsystems you will use and the subsystems you will create.
•    Submit your proposal via email to your instructor for approval. Your instructor will approve or deny the proposal. If denied, your instructor will provide guidance regarding the changes required for approval and ask you to resubmit the proposal.
•    Following are examples of the types of projects that would qualify. These are only examples and you are encouraged to think of others.
o    Checkout/payment process for an online store (could use external payment system as a subsystem and your code integrates with this system)
o    Service location Web site (could use a Web map system for directions and your code integrates with this system)
o    Project time tracking system (could use a Web service to receive time logging information from a simple Web form and your code would create and use the Web service)

Module 1 – SLP/PROJECT REQUIREMENTS.

Systems integration requires the blending of existing and potentially new components to create a business process solution. The SLP assignments in this course are designed to lead you through the steps required to complete a systems integration project. In this first SLP assignment you will select a project and write the requirements for the project.
Project Selection
IMPORTANT: Project selection must be completed and approved by Friday of the first week of the course. Failure to get your project approved by this due date will reduce the time you have available to complete the graded part of this SLP assignment (requirements) and will impair your progress in Module 2.
For the course project you will select a systems integration project that solves a business process problem. The business process you select will guide you through the rest of the SLP assignments so careful consideration of the project and good communication with your instructor are important at this point.
Points to consider in project selection:
•    The project must integrate new or existing systems to address a business process.
•    The project should not be too complex although it should be sufficient to allow you to demonstrate the skills you have learned in the courses taken prior to this course.
•    You should have access to any subsystems or information required to complete the project.
•    You will need to create some portion of the project (i.e., you cannot just use existing systems). At a minimum, you will need to create some portion of the system that integrates the other subsystems. Your work must include some programming (language of your choice) and the use of a database for some aspect of the project.
•    It is highly desirable to create a Web-based application for this project due to the availability of Web services that are useful for integration purposes. Web-based applications can also be operated on publicly available Web sites which will make them easier to deploy and evaluate. If you choose to create a Web-based project, be sure to check the availability of scripting, server-side coding, and database capabilities on your Web hosting server. You may not have a significant background in Web application development. Some background on Web development and Web Services was provided in the standard curriculum and examples are provided in the reading materials for this course. The type of Web application required to integrate Web Services and create and integrated system are not overly complicated and can be created in languages you are probably familiar with already (PHP, Java, C#).
For your consideration, you may wish to review material in previous courses as useful resources for your project:
•    You may go through CSC212 to demonstrate the ability to use Eclipse IDE for Java Development and touch the nature and scope of Object Oriented Programming.
•    You may go through CSC230 to learn about different search and sort algorithms, and data structures.
•    You may go through CSC310 to use some important programming topics such as error checking, file processing, database connectivity, web applications, and web services.
•    You may go through CSC316 in terms of database design in order to design the required tables, draw an Entity Relation Diagram and construct project normalized database.
•    You may go through CSC317 to understand how to use SQL statements to generate reports and use JDBC API for accessing a database from Java applications.
SLP Assignment Expectations
Project Proposal (non-graded)
•    The proposal is due by Friday of the first week of class.
•    Write a short (1- to 2-paragraph) description of the business process you want to address in the project. Include a discussion of the existing subsystems you will use and the subsystems you will create.
•    Submit your proposal via email to your instructor for approval. Your instructor will approve or deny the proposal. If denied, your instructor will provide guidance regarding the changes required for approval and ask you to resubmit the proposal.
•    Following are examples of the types of projects that would qualify. These are only examples and you are encouraged to think of others.
o    Checkout/payment process for an online store (could use external payment system as a subsystem and your code integrates with this system)
o    Service location Web site (could use a Web map system for directions and your code integrates with this system)
o    Project time tracking system (could use a Web service to receive time logging information from a simple Web form and your code would create and use the Web service)