Syllabus for ISMG 6280
Systems Integration and Client Server Computing
Spring 2005
,  T 6:55 - 9::35 KC 103


Course Instructors:

Professor  Jahan Karimi

Linda Fried

Office:

1250 14th Street, Room 224

 

Office Hours:

14:00 to 15:30 W: R  and by appointment

Office Phone:

303-556-5881, 303-556-5899 (Fax)

 

E-mail:

jkarimi@carbon.cudenver.edu

linda.fried@cudenver.edu

My Home Page

IS Program Web Site

http://carbon.cudenver.edu/~jkarimi/index.html

http://thunder2.cudenver.edu/newprogram/

 

Texts:

 

On-line source for text books:

Required:

  1.  The Essential Client/Server Survival Guide (SG),   Robert Orfali, Dan Harkey, and Jeri Edwards. 3rd edition, Wiley, (1999).

  2. Building the Data Warehouse (BD), Inmon Wiley-QED

  3. Oracle Developer & Reports,Koletzke and Dorsey, Oracle Press, 0-07-212048-7

Optional:

  1. Oracle 10g The Complete Reference, Loney and Koch, Oracle Press, 0-07-225351-7

  2. Oracle9i PL/SQL Programming, Urman, Oracle Press ,0-07-219147-3.

 

 

 

 

 

 

 

 

 

 

Course Description Course Objectives
Course Prerequisite Policies
Grade Determination Projects
Electronic Mail Data Warehousing Links

Return to Dr.J Karimi Homepage...


COURSE DESCRIPTION:

This course covers the development of an integrated technical architecture (hardware, software, networks, and data) to serve organizational needs in a rapidly changing competitive and technological environment; the task of defining, designing, building, testing and rolling-out a system comprising many hardware and software components. It covers the fundamental issues associated with reengineering of legacy systems, data, application, and network integration in a distributed client server computing environments.

Return

 

COURSE OBJECTIVES:

Topics will include  reengineering of  legacy systems, data architecture, data warehouse design and implementation, operating systems and network protocols, network interface and applications middleware, transaction processing monitors, J2EE, Dot Net, and web services platforms, and migration to architected environments.  Students will develop applications using Oracle database developer forms and reports. 

Return

COURSE PREREQUISITES:

The prerequisites to this course are ISMG 6080 and ISMG 6120.

Return


 

POLICIES

Late work: Late work will be accepted up to one week following the scheduled due date. Late work is subject to a penalty of 10% of the maximum possible credit for the assignment.

Participation: Active participation in these class discussions is an important component of this course. Regular attendance is required. Note that attendance is distinct from participation. It is expected that students will enrich the course through relevant questions and contribution of personal knowledge and experience.

Reporting Absences: As a courtesy, the instructor requests an e-mail message in the event a student will be unable to attend a scheduled class session.

Examination Policy: Attendance at examinations is mandatory. Make up exams are not typically given. The only acceptable excuses for missing an exam are circumstances clearly outside your control, such as illness, death in family, etc. If you miss an exam, notify me as soon as possible. I may require documentation of the circumstances.

Scholastic Dishonesty: Any time you put your name on a piece of work for this course, you are asserting that it is your own work, except as otherwise indicated and permitted. If that is not the case, it is academic dishonesty, and under Business School rules, I am required to submit the matter to the College Internal Affairs committee for a decision. Regarding plagiarism, the source of any information you use must be reported using an appropriate citation format. Direct quotations must be indicated with quotation marks and page references.

Return

 

 

Grade Determination

Below is the weight given to each assignment and exam. Failure to attend class regularly and to participate in class discussions will negatively impact your grade.

Projects

30%

One

8%

Two

14%

Three

8%

Exam 1

25%

Exam 2

25%

Exam 3

20%

Class Participation &
Instructor's discretion

(+/-) 5%

Letter grades will be assigned using the following scale:

A A- B+ B B- C+ C C- D+ D D-
95% 90% 87% 83% 80% 77% 73% 70% 67% 63% 60%

At the discretion of the instructor, grades may be "curved." However, no student will receive a grade less than that prescribed by the above schedule.

Return


PROJECTS

Projects are individual projects (group of one). There will be absolutely no extensions to any deadlines.

Projects Submission: You should submit your projects to the backboard system. In no case you should submit your projects to me via an e-mail attachment. Such submissions will be deleted without grading.

You need to use either the Oracle 10g Database or the Oracle 9i Database and Developer Forms and Reports in your projects. Currently, the 10g Client is still the exact same Client as the 9i Client, so if you already have that installed, you do not need to upgrade.  New also this year, if you have a previous version of Oracle, you may upgrade during installation, instead of running a complete install.  To purchase the correct CD packs, you need to go to the Oracle Store at  http://oraclestore.oracle.com/ , and choose “United States”.  You will want the Oracle Standard Edition.. There are installation instructions for Windows 2000, and EXP on the course schedule and on the blackboard. You may also download the Oracle Database (recommended) from Oracle at the link below The Oracle 10g Server, which you do not need to download, has changed significantly. The Oracle 10g Developer Suite is also still actually the Oracle 9i Developer Suite.  If you need to download it, go to: http://www.oracle.com/technology/software/products/ids/index.html, and select the appropriate operating system platform.

 Software Required For this Course:

Free Download from Oracle Website:

  1. Make sure to have an account on Oracle MetaLink at http://www.oracle.com/support/metalink/index.html.  This will allow you access to online support and articles.
  2. Oracle 10g client link: http://www.oracle.com/technology/software/products/database/oracle10g/index.html. Download the appropriate version for your operating system For example, Oracle 10g server, 10g client for Linux, 10g Developer for Linux: http://www.oracle.com/technology/software/products/database/oracle10g/index.htmlIf you wish to download the 9i client instead (it is the same software), please use this link, and select the Oracle 91 Release 2 for your operating system: http://www.oracle.com/technology/software/products/oracle9i/index.htmlOr, if you wish to only download the Client, the Oracle 9i client, 32 bit Windows is located at: http://www.oracle.com/technology/software/htdocs/devlic.html? http://otn.oracle.com/software/products/oracle9i/htdocs/win2k3soft.html, and the Oracle 9i client, 64 bit Windows is found at: http://www.oracle.com/technology/software/htdocs/devlic.html?http://otn.oracle.com/software/products/oracle9i/htdocs/win64soft.html
  3. Oracle 10g Developer link:  http://www.oracle.com/technology/software/products/ids/index.html.  Download the version appropriate to your operating system.  If you plan to run it from your own server, then you will need to download the Oracle 10g Application Server as well at: http://www.oracle.com/technology/software/products/ias/devuse.html.  You may still use the Oracle 9i DS (Developer Suite) and AS (Application Server) located at: http://www.oracle.com/technology/software/products/forms/index.html

How to Purchase: (Incase of low connection speed to download from Oracle website)

  1. Go to the link: http://oraclestore.oracle.com/
  2. On the left hand side of you see "CD Packs" under Oracle Store. Click on it.
  3. Under  “Purchase A CD pack” section, click on your operating system. Ex: MS-Windows.
  4. Then click on the check box of the following.
  5. Purchase Oracle9i Database Release 2 (9.2.0.1.0) CD Pack for Microsoft Windows  ($39.95)
  6. Purchase Oracle9i Developer Suite, Release 2 (9.0.2.0.1) CD Pack (with iAS Pack) for Microsoft Windows  ($79.90)
  7. You can see the contents of the CD pack by clicking on the link. It contains the Oracle 9i database Enterprise edition along with Forms & Reports.
    So you don't need to Order “Oracle database Personal edition”. Both works the same for our class purposes and there won’t be any compatibility issues.
  8. Now click on “Add to Cart”.
  9. Don’t worry about the license jargons and 30day trail licenses. The license is for Support and Upgrades. We don’t need any support or upgrades for our class purpose. Anyway it is difficult to get a oracle support person on the phone to resolve our oracle problems.

 ORACLE Documentation

For information about all ORACLE Products and Documentation (Installation information) you need to access this web site  http://technet.oracle.com/software/ . When you go to the site you need to (1) register by clicking on the membership, (2) select the product you want, and (3) click on the documentation.

Oracle Installation Guides: Check the course schedule page. These installation guides can also be obtained on oracle's website http://otn.oracle.com/docs/index.htm.  Oracle By Example has a number of tutorials available for your use: http://www.oracle.com/technology/obe/start/db.html .  Select the appropriate version of Oracle. You can also get free membership on the oracle website. Visit the following web site for free membership Oracle Academic Initiative

  Return

ELECTRONIC MAIL

E-Mail: Each student enrolled in this course will receive an account on Blackboard http://www.cuonline.edu/ . You need to access the blackboard and maintain your personal information on the system. You need to submit one zip file containing all the files associated with your project. To submit your file , you need to (1) upload the file, and (2) send the file. If you just upload the file, you can see the file in your in box but I cannot access it.

The information related to assignments, exams, course schedule changes, and other general course information will be posted to my home page and on the Blackboard. The URL for my home page is: http://carbon.cudenver.edu/~jkarimi/index.html. I will also be sending more urgent announcements to the class via blackboard, and will be happy to answer any questions about assignments, etc., via email.

Return

DATA WAREHOUSING LINKS

Oracle Academic Initiative Oracle University
The Data Warehousing Information Center Data Warehousing Institute

Return