Wayne State University

CSC 5710 – 001 (Section 42084)
Design of Intelligent Information Systems
SPRING/SUMMER TERM - 2001 


===============================================================

Instructor Information:
Name: Joseph D. Ramsey
Class Hours: M, W, 137 State Hall. @ 4:30 PM - 5:50 PM
Office: 462 State Hall (6:00PM – 6:30PM or by Appointment)
Tel:  (313) 964-9299 (Work) 
      (313) 577- 3104 (Office)
E-Mail: ramsey@cs.wayne.edu  
(http://www.cs.wayne.edu/~ramsey)

 

  Prerequisite:
CSC 4710 - Information Systems Design: Database life cycle, conceptual modeling and implementation, relational model, network  model, hierarchical model, design and implementation of  an information system utilizing a commercial database (oracle, Sybase, Informix, mysql, and object databases such as salsa).

 

  Description:
This course introduces the student to object-oriented modeling techniques for analysis and design of database applications.   The emphasis will include techniques for designing both the structural and behavioral aspects of the systems.  We will explore detailed design using the Object Modeling Technique (OMT) notation.  That will involve methods for mapping a detailed design into language constructs for underlying operating systems and network mechanisms.  We will explore the ramifications of various hardware choices for the design, as well as the effects of software structure on system performance.  The student will demonstrate his or her understanding of the materials through incremental homework assignments, and through the analysis and design of a reasonably realistic database system that includes concurrent and distributed components.

 

Team Project: Database-Driven Webs
One of the hottest areas of Internet activity today is electronic commerce. The team project will involve using the three-tier design methodology to develop a backend database using available commercial databases and open source tools. The objective of the project is to allow groups to interact in real world-like publishing data on the web. Browser interacts with hypertext markup language (HTML), application servers, and database queries to present information as requested. Groups will create online commercial transactions, totally database-driven (relational, object relational, or object-oriented), middle tier will involve scripting languages such as asp, JavaScript’s, visual basic, tcl, PhP and host of others that implements functionality to browsers.

 
  Objectives
At the end of this course, the student should be able to:
  1. Understand the fundamental concepts and notations available in OMT.
    2.
  2. Apply object-oriented analysis and design techniques to design relatively complex software systems.
  3. Understand the issues involved in mapping an object-oriented design to specific language environments, operating system services and networking mechanisms.
  4. Understand the general performance ramifications of various design choices.

  5. Understand the fundamental concepts of intelligent office information systems, decision support systems, deductive databases and  hypertext.

    The student must demonstrate his or her mastery of the material by designing and building a prototype of  a "real world" database application using the concepts listed above.

 
Class Policies  
  1. Make-up exams will only be arranged if your alibi is substantiated with valid proof of unforeseen circumstances.
  2. Lectures will include additional material not present in the textbook, hence class attendance is very important.
  3. The student is responsible for the readings before each class session.
  4. Class participation, class attendance, and the student's attitude are important factors that are considered when grades are given.
  5. No late homework assignments will be accepted. Instead, the grade of the lowest homework assignment will be dropped when computing your score.

 
Textbooks
Required:  Object-Oriented Modeling and Design for Database Applications.  Prentice Hall, 1998 (ISBN: 0-13-123829-9).

Blaha Michael, and William Premerlani

 
Optional:  An introductory database textbook/E-Commerce/ XML textbook.

 
The final Grade will be calculated as follows:
Average of Homework 10%
Midterm 15%
Final 20%
Individual Project 15%
Group Project 40%

 

Assignment due dates:
Assignment No.1. - May 21, 2001
Assignment No.2. - June 11,2001
Assignment No.3. - July 02,2001
Assignment No.4. - July 16,2001

 
Midterm Examination: Wednesday June 27, 2001
Final Examination: Wednesday July 25, 2001

 

A final letter grade will be determined as follows:
A  : 92 – 100%
A- : 88 – 91%
B+: 85 – 87%
B  : 82 – 84%
B- : 78 – 81%
C+: 75 – 77%
C  : 72 – 74%
C- : 68 – 71%
D+: 65 – 67%
D  : 62 – 64%
D- : 58 – 61%
F  : LESS THAN 57%

 

A grade of incomplete (I) will not be given. All students should show the highest level of academic honesty in all related exams, assignments and project. Graduate students passing grade is at most 77% and above.