|
Welcome
Administrivia
Course
Objectives
Catalog
Description
An
Honest Description
Textbooks/Readings
Requirements
Grading
About
Instructor
Tentative
Schedule
|
Welcome to Acc 683 and
to the world of electronic commerce. This course is not
a requirement for the one-year or two-year M.S. Degrees in the
Department, and therefore I assume that you have made a committment to
be an information systems professional. I also assume that you are
curious, and passionate in learning about information systems by DOING,
i.e., by programming, and not hearing or talking about them. If not,
you will be doing yourself a favour by looking elsewhere to cover your
semester schedule. If you do continue in the course, I expect you to
be deeply committed to the field of information systems, passionate
about learning new things, and demonstrate such passion and
committment by setting this course (along with Acc 680) at the
TOP of your priorities.
I shall assume that
you have had Acc 681 and Acc 682 during the fall semester. If you have
not had them, I assume that you are quite familiar with the Java
programming language (including the skills related to reading and
using Java JDK (Standard Edition) API documentation, fundamentals of
relational database theory, SQL, ODL, Basic JDBC programming,
knowledge of data structures to the extent covered in Acc 682, and, of
course, the background in using unix operating system.
During
the course of this semester you will have ample opportunity to gain an
understanding of the languages UML, XML as well as many features of
J2EE (Java 2 Enterprise Edition), as they are used in the development
of systems for electronic commerce using the three-tier model. Since I
expect you to be quite familiar with database logic, the emphasis in
the course will be on application logic (using Java servlet APIs, Java
Server Pages APIs among others), and presentation logic (XML and
XSLT).
I shall be using ORACLE database management system
for most class-work, you will have ample opportunity in the course,
should you wish, to experiment with most commercial-grade database
management systems such as IBM's DB2 or Microsoft's SQLServer 7. I
shall also be using either the CASE tool Together Control
Centre (TCC) or Rational Rose Enterprise Edition,
both of which will be available in the Arthur Andersen Lab. All
homework assignments, however, must be done using the Oracle DBMS on
cayley.bus, and the programming, unless otherwise permitted by me, on
the unix cluster. Should you do the java programming on the Windows
2000 workstations/servers in the lab, you will be on your own except
for some basic help from the graduate assistants.
The group
project in the course can be done using any software you wish to use,
but you are responsible for their management.
You have access
to one of the finest stocked (in terms of hardware as well as
software) computing facility any where in the Arthur Andersen
Laboratory. We have most major industrial strength databases (Oracle,
DB2, and SQLServer) as well as toy database systems such as Microsoft
Access and Visual FoxPro. Use the lab, and enjoy the course!
TOP
Semester:
Fall, 1999 Time: MW: 5:45 - 8:35 PM Room: BA
223 (PriceWaterhouseCoopers Classroom) Instructor: Jagdish
S. Gangolly Graduate assistants:Jongwoo Park Office:
BA 365AC Phone: (518) 442-4949 Fax: (707)
897-0601; (518) 442-3944 Office Hours: M: 4:30 -
5:30 PM. or by appointment Instructor Homepage: http://www.albany.edu/acc/gangolly Newsgroup:
sunya.class.acc683
Class
Conduct: The course consists of lectures, solution of
problems, short cases, and discussion of late-breaking developments in
the field. You are expected to do the readings well ahead of the
class. Class time is to be used for the clarification of any doubts
that you may have. Do not expect to merely listen to the instructor
and gain knowledge. Databases is a practical field backed by robust
theory. A good understanding of the theory and its use in practice is
essential to excel in the field. This is a hands-on course, and you
are required to demonstrate competence in the topics covered in order
to receive an acceptable grade. I shall be giving quizzes and
occasional homework assignments. I also shall be calling upon some of
you to come to the board and solve problems assigned.
Software: I
shall be using most software under unix, and expect you to use cayley.bus.albany.edu
to write and test most programs. I shall also be providing hints on
doing the same things under Microsoft windows 2000.
Most
software we will use is available free on the internet for both unix
and windows. Those of you using your PCs at home may like to download
Microsoft Windows 95/98/2000 version of software and use it. My
graduate assistant(s) and I will provide some support, but you are
expected to be self-reliant. During the semester, I shall provide you
with sources for Java2, JDKs, Webservers, XML parsers, XML APIs, etc.
via this page. Therefore you are expected to visit this page very
often.
Newsgroup
and e-mail: I shall be using the class newsgroup
(sunya.class.acc683) extensively for making announcements regarding
tests, homework, quizzes, added links to this course homepage, etc. In
fact, the newsgroup will be the primary means of communication between
us outside of the class. You should post to the newsgroup all your
questions and doubts for clarification. Use it as a sort of virtual
classroom. You are strongly encouraged to answer queries posted by
others, and such responses will count towards class participation
points for grading.You should communicate with me via e-mail only for
individual problems and questions.
Arthur
Andersen Laboratory Access: As a graduate student in the
Department, you have access to the Arthur Andersen Laboratory. You
will need to get from Ms. Lisa Scholz the password to enter the lab.
Contact her in BA 365 as soon as possible. Should you have special
requirements for software (DBMS servers) or hardware (Windows 2000
Servers) for your projects, let me know, and arrangements will be
made. for your access.
You also will need logins to the
University unix cluster and the Department's Windows 2000 server. You
will need to apply on-line for an account on the unix cluster, and
contact Jongwoo Park regarding login for the Windows 2000 server. You
can not use any machine in the lab without these logins.
TOP
The main objectives of
the course are:
TOP
Topics
relating to emerging technologies that affect accounting and auditing
practice, including topics such as expert systems in accounting &
auditing, groupware systems for auditing, retrieval of audit data.
TOP
Web
application development to support Electronic Commerce including the
technologies to support it, such as Extensible Markup Language (XML),
Java Database Connectivity (JDBC) and Java Servlets. The emphasis will
be on gaining hands-on experience in building such applications
TOP
The main textbooks for
the course are:
 |
Professional
Java Server Programming J2EE Edition ,
Hardcover - 1632
pages 1st edition (September 2000) Wrox Press Inc; ISBN:
1861004656 JSP in the tentative schedule below. |
 |
The
Unified Modeling Language User Guide (The Addison-Wesley Object
Technology Series)
by Grady Booch, Ivar Jacobson, James Rumbaugh, Jim Rumbaugh.
(Hardcover - 482 pages (October 30, 1998) Addison-Wesley Pub Co;
ISBN: 0201571684)UML in the tentative schedule
below. |
 |
Java
and XML by
Brett McLaughlinPaperback - 498 pages 1 edition (June 2000)
O'Reilly & Associates; ISBN: 0596000162 ). JAX
in the tentative schedule below. |
You also must refer to the following
resources:
In addition to the
above, I shall be assigning additional resources to be used. They will
be mostly the specifications and recommendations of the World Wide Web
Consortium (www.w3c.org).
We will not have time
in the class to go over each and every minute detail of the various
xml applications. Therefore, you will need to do much of the readings
from the assigned sources. You will need those details in order to
successfully complete the semester group projects. You are most
welcome to ask for clarifications of the materials in these books
either on the class newsgroup or during my office hours either
individually or in groups.
TOP
The classes will
consist of lectures, solution of problems, discussion of cases and
programming exercises. I shall be dividing the class into groups of
3-4 each, balanced in terms of skills in accounting, programming,
facility with computers, mathematical maturity, needs of the projects
selected, and other such attributes. The groups will work through out
the semester in one group project:
TOP
The final course grade
is dependent on the following factors:
The final course grade is strictly
relative, based on the total points scored.
The grades, once assigned can not be
changed except in case of errors in grading. It is NOT possible to
do extra credit work to improve the grade.
TOP
Jagdish S. Gangolly is
currently an Associate Professor of Accounting and of Management
Science & Information Systems in the School of Business, and a
Senior Program Faculty member of the Ph. D Program in Information
Science. He holds a Bachelor's degree with a major in Mathematical
Statistics, a master's degree with a major in Operations Research, and
a Ph. D degree in Accounting. He is also a Certified Internal Auditor.
He has previously taught at the University of Pittsburgh, University
of Kansas, Claremont McKenna College & the Claremont Graduate
School, and California State University at Fullerton. He has worked in
senior executive positions in management services in the pulp &
paper industry as well as in soft-drink franchising. His articles have
appeared in Journal of Accounting Research, Auditing:
Journal of Practice & Theory, Journal of the Operational
Research Society, Critical Perspectives on Accounting,
Expert Systems with Applications: An International Journal,
and Artificial Intelligence in Accounting & Auditing. In
1989, he was the guest editor of Advances in Accounting;
currently he serves on the editorial board of the American Accounting
Association journal Issues in Accounting Education,
the International Journal of Digital Accounting Research,
and is an Asociate editor of the e-Services Journal.
His current research activities are primarily in the areas of
conceptual information organisation, markup languages supporting
electronic commerce, and the formal specification of control in
accounting information systems. He also has collateral research
interest in the relationships between Accounting and Legal Philosophy.
TOP
February
14, 2001
Theme:
Introduction to XML
II
Topics: XML
Parsing, Document Object Model (DOM) and Simple API for XML (SAX).
Read:
JSP
Ch.6; JAX Ch. 1-3.
February
19, 2001
Theme:
NO Class (Presidents' Day)
February
21, 2001
Theme:
Java Servlets, Powerpoint
Read:
JSP: Ch 7, 8.
DO:
Homework IV, Homework V
February
26, 2001
Theme:
No Class (Winter Break)
February
28, 2001
Theme:
No Class (Winter Break)
March 5,
2001
Theme:
Topics:
Browse:
March 7,
2001
Theme:
Java Servlets: Session Tracking (Powerpoint)
Topics:
Browse:
March 12,
2001
Theme:
XML Validation & DOM Powerpoint
Topics:
Browse:
March 14,
2001
Theme:
TEST (5:45 - 7:05) &
Group Presentations (7:15 - 8:35)
TOP
|