MSI 602 - Advanced Concepts in Information Systems II Enterprise Application Development

University at Albany, SUNY

 Spring 2004

Instructor Information

Name:	Sanjay Goel
Email:	goel@albany.edu
Phone:	(518) 442 4925
Office Hours:	By appointments
OfficeLocation	BA 310b

Class Information

Time:	Tuesday, 9AM - 12AM
Venue:	BA 233
Dates:	January 28 - May 6 2003 (Detailed schedule at end)
Available Labs:	MIS Lab, HRIS Lab

Course Overview

This course teaches students how to plan and implement an online business. The class is broken down into groups of about 4 students. The course begins with each group brain-storming to generate new ideas for an online business. Over the first four weeks students learn about financial analysis, marketing analysis, and risk analysis. Thereafter each group takes their ideas and evaluates them for feasibility and selects one idea for implementing a business. At the end of five weeks each group presents their business plan which is evaluated by a set of external reviewers.

The students spend the next six weeks understanding the architecture and technology (Java/J2EE) for developing multi-tier (client/server/data) systems. The students spend 1-2 two lectures studying the technology behind each of the tiers in their enterprise application. The database tier design require the students design their databases and connect to them from Java code using JDBC. The server tier design involves use of servlets and JSPs to encapsulate the business logic in the application. The client tier involves the developing of web pages using html or some web development tool. The students complete the implementation of their system by the end of the 12th week and present their projects to the Chamber of Commerce (or other industry representatives) and give a demonstration of the projects.

In the last phase of the class the students learn about XML and Web Services and their role in enterprise application development. The course also covers security in the design of enterprise applications. Security curriculum involves role-based access control as well as authentication and authorization for mobile code based applications. The class will require some programming, thus knowledge of Java Programming will be very useful.

Books & Software

Text Book	Professional Java Server Programming J2EE Edition by Allamaraju et.al., Wrox
Reference Book	Professional Java Security Programming, Jess Garms & Daniel Somerfield, Wrox
Reference Book	The Complete Book of Business Plans by Covello and Hazelgren
Reference Book	Java by Dissection: The Essentials of Java Programming by Pohl & McDowell, McGraw Hill

Grading

Assignments	20%
Project	50% (10% business plan, 10% data-tier, 20% 3-tier architecture)
Final Exam	30%

Class Project

Students will need to form a group project team with 3 to 4 students per team. Each team will develop a three tier enterprise application which will involve development of web pages, servlets and connection to a database (Access or Oracle) using JDBC. One of the projects could be an online retail store which sells a variety of goods such as books, toys and CDs. The team project will include a final project report as well as a presentation in the last class. The students will be evaluated on the report, presentation and the quality of the software developed. A more detailed description of the project is provided in a separate project document.

Assignments

Assignments given in any week are due at the beginning of the class on the same day in the following week. There will be a penalty of 10% per day for late assignments unless there is a very pressing reason for the delay. Please work individually on all assignments. Stop by my office (BA 310b) if you have difficulty in understanding the assignment or the course material related to the assignment.

Course Schedule

Week	Date	Topics	Readings
1		Introduction to the course, objectives, expectations, and deliverables Introduction to e-commerce, e-business Business models in e-commerce Class Assignment: Three Unique Ideas per team	Class Notes
2		Developing a business-plan Elements of a Business Plan Business Metrics Class Assignment: Pick an idea and develop a rudimentary business plan	Class Notes
3		Financial Analysis of Business Plans Class Assignment: Each student presents a rudimentary financial analysis of their business plans	Class Notes
4		Each team presents their proposals. The proposals are critiqued and graded for their idea, content, thoroughness and due-diligence. Students are expected to submit their final business plans at the end of the class.	Class Notes
5		Review of Databases and SQL Java Database Connectivity Class Assignment: Write Software to connect to a database and write simple SQL statements to get database.	Professional Java Server Programming (ch. 4
6		Spring Break
7		Multi-tier Architecture for enterprise systems Web Containers, Servlet Programming, web servers Class Assignment: Write servlets and execute them in the Tomcat environment	Professional Java Server Programming (Chapter 5/6)
8		Sessions, Context & Collaboration Class Assignment: Write application for session tracking using servlets	Professional Java Server Programming (ch. 6/7)
9		Web deployment , authentication and packaging War files, mapping requests Class Assignment: Take two servlets, establish communication between them and deploy them on the server	Professional Java Server Programming (ch. 9)
10		Security in Design of Enterprise Applications Class Assignment: Create an application for Role Based Access Control	Professional Java Security Programming (ch. 10)
11		Java Server Pages Class Assignment: Write a JSP code for a sample problem provided in class	Professional Java Server Programming (ch. 10)
12		Extensible Markup Language (xml) XML APIs Class Assignment: Write an application to parse an XML document and extract information	Professional Java Server Programming (ch. x)
13		Exam
14		Present the final projects (Review Board)
15		Current Topics