Acc 683 Topics in Accounting Information Systems (Web Application Development & XML






Welcome

Administrivia

Course Objectives

Catalog Description

An Honest Description

Textbooks/Readings

Requirements

Grading

About Instructor

Tentative Schedule

Welcome

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


Administrivia

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


Course Objectives

The main objectives of the course are:

  • To gain an understanding of the object-oriented modeling using UML.
  • To gain a basic understanding of XML and XSLT, and an in-depth understanding of JDBC in the context of accounting systems.
  • To gain an understanding of the architecture and working of three-tier web applications using XML/XSLT, JDBC, Servlets, JSP, etc.
  • To gain an in-depth understanding of XML Schema, Namespaces, X-path and X-pointers; use of xml parsers, and the Document Object Model.
  • To develop skills in database connectivity through JDBC. (basic knowledge already assumed).
  • TOP


    Catalog Description

    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


    An Honest Description

    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


    Textbooks/Readings

    The main textbooks for the course are:

    {short description of image}
    Professional Java Server Programming J2EE Edition , Hardcover - 1632 pages 1st edition (September 2000) Wrox Press Inc; ISBN: 1861004656 JSP in the tentative schedule below.
    {short description of image}
    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.
    {short description of image}
    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


    Requirements

    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


    Grading

    The final course grade is dependent on the following factors:

  • 100 points: Test (In class open book/notes. Details will be announced in the class and updated here)
  • 200 points: Group Project
  • 0 - 50 points: Pop-quizzes/homework, when given
  • 25 points: Class participation
  • 325 - 375 points: Total points (max)
  • 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


    About Instructor


    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


    TENTATIVE SCHEDULE

  • January 22, 2001
  • Theme: Introduction to Three-tiered Web Application Architecture
  • Topics: History, Architecture, Future.
  • January 24, 2001
  • Theme: Introduction to UML I
  • Topics: Basic concepts in systems analysis & design. Architecture of UML
  • Read: UML Ch.1-8.
  • Do: The Sales Invoice example given during the class.
  • January 29, 2001
  • Theme: Introduction to UML II
  • Topics: Basic diagrams in UML for the documentation of information systems II
  • Read: UML Ch. 1-12.
  • Do: JDBC homework given out during the class. Due in two weeks.
  • January 31, 2001
  • Theme: No Class.
  • Read: UML Ch.13-21 for the next class.
  • February 5, 2001
  • Theme: Introduction to UML II
  • Topics: Basic diagrams in UML for the documentation of information systems
  • Read: UML Ch. 1-12.
  • Do: JDBC homework given out during the class. Due in two weeks.
  • February 7, 2001
  • Theme: Introduction to XML I
  • Topics: Basic concepts of document design. Basic concepts of XML. Document Type Definitions. Wellformedness and validation. Databases and XML. UML models for tag design in XML.
  • Read: Any XML tutorial on the internet. JSP Ch. 5-6.
  • Do: Homework on Sales Invoice example.
  • February 12, 2001
  • Theme: Introduction to Servlets
  • Topics: Basic concepts of threads and thread model in Java. Web containers. HTTP request/response model. Session management in servlets. Servlets configuration and lifecycle.
  • Read: JSP Ch.7-9.
  • Do:
  • Homework Assignment 2 (Due February 19, 2001
  • Group Assignment
  • 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


    Updated on March 18, 2001 by Jagdish S. Gangolly.