CIS458 E-business Applications Development with Oracle

Instructor: Dr. M. Wang

Office: ST #609

Office Phone: (323) 343-2983

Direct Phone: (323) 343-2958 (Use for office hours)

Office Hours:  Thursday 3:00 - 6:00 p.m. and Friday 3:20-4:20 p.m.

E-mail: wangm999@gmail.com
Web Site URL: http://www.calstatela.edu/faculty/mwang3/

Electonic downloads:

http://java.sun.com/docs/books/jdbc/index.html

Reference Book:

· JDBC API Tutorial and Reference by Fisher, Ellis and Bruce, Third Edition, Sun MicroSystems

· Core Servlets and JavaServer Pages by Marty Hall and Larry Brown, Second Edition, Sun MicroSystems

Free online version http://pdf.coreservlets.com/

Software Tools: Oracle Enterprise, JDK Version 1.3 or above and Oracle JDeveloper Suite

Internet Utility Tools: FTP, Telnet

Web Server Middleware: Apache

Operating Systems: Windows 2000 and Sun Solaries 5.8

Course Description:
The course introduces database application programming using Oracle and Java for Windows and Internet using JDBC. Projects reflect real-life problem-solving skills in the e-business world. The course helps prepare students for the Oracle Application development Certification Exams.

Prerequisite:
Experience in using relational databases or CIS405a and a high-level programming language with Java.

Objectives:
After successful completion of this course the student should be able to:

Develop Oracle database application programs using JDBC connectivity.

Deploy Oracle database applications on the Web server using JSP/Servlet

Utilize Oracle JavaBean components

Create, store and execute PL/SQL units

Deploy Oracle database applications on the Web server using JSP/Servlet and PL/SQL

Instructional Procedures:
Classroom activities will consist of lecture, example demonstration and in-class exercises. The contents taught in class will be followed by homework assignments, projects and exams.

Assessment of Academic Achievement:
Assignments (20%),

Project Part I: Database Design and Implementation (8%)

Project II: Database Application Programming (8%)

Mid-terms (28%)
Final Exam (36%)

The final grade will be determined on the above performance.

Grading scale: A 90-100%, B 80-89%, C 70-79%, D 60-69%, F 0-59%

CLASS POLICIES:

Projects and Assignments: Students are expected to accomplish their projects and assignments independently. Requests for debugging your program via email will not be responded. Students are expected to use the equipment of computer labs at CSULA for assignments and projects.

To receive full credit, a project or an assignment must be completed on time on the date due. Work load and other course load will not be excused. Late penalties will be assessed as follows:

Up to 24 hours after time due --- 25% penalty
Over 24 hours after time due --- 100% penalty

Tests: Exams are cumulative in nature for this programming class. Absence from a test is excused only in a personal medical emergency.

Responsibility: Class attendance is required. Important work will be done in class. Regular attendance will improve your performance. Students will be responsible for all course assignments, lecture notes, handouts and announcements via postings to the class web site. If class is missed, it is the student's responsibility to drop any assignments due at the Department's office with time stamped. Make sure you receive a receipt acknowledgement if you have to e-mail a softcopy assignment to the instructor in a special situation.

Honor code:  All students are expected to act with honor and integrity in completing their academic requirements. Dishonesty and cheating will not be tolerated. This behavior will result in an F (zero points) on that assignment and possible expulsion from the course (an F in the course).

Class conduct:  Common courtesy and respect of all people and property expected. Punctual arrival of the class required. NO cell phones or beepers in class.