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.
Web Site URL: http://www.calstatela.edu/faculty/mwang3/
· 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
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.
Experience in using relational databases or CIS405a and a high-level programming language with Java.
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
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.
of Academic Achievement:
Project Part I: Database Design and Implementation (8%)
Project II: Database Application Programming (8%)
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%
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 ---
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.