CSC4710: Information Systems Design

(Fall 2007)

(Class: TuTh 4:30-5:50PM, State Hall 313)

Webpage: http://www.cs.wayne.edu/~shiyong/csc4710/csc4710.html

Announcements:

  • Final exam review questions for Tuesday 12/11/2007, ignoring problems 3 and 4.
  • Project part 3 is extended to Friday 12/14/2007 midnight.
  • In class exercises for normalization theory.
  • Project part 3 is out. Due 12/11/2007 midnight.
  • Assignment 1 and quiz 1 are extended to this Thursday (11/9/2007) in class.
  • Project part 2 is extended to 11/20 midnight.
  • Assignment 2 is out. Due 11/29/2007 midnight.
  • In class exercises for relational algebra and SQL
  • Project part 2 is out. Due 11/8/2007 midnight.
  • Assignment 1 is out. Due 10/30/2007 midnight. Send the submission electronically to the TA.
  • Project part 1 is out. Due 10/11/2007 midnight. Any questions about the project please contact the TA.
  • Classroom is changed from State Hall 213 to State Hall 313.
  • Each individual student can have an Oracle account. To get one, please send an email to Mr. Bogdan at boc@cs.wayne.edu (or bcapatin@ford.com) with the subject "CSC4710 Oracle account request". He is the Oracle database administrator. Any problem with your account should be addressed to him with detailed information. Please request the Oracle account as soon as you can.
  • Log in at http://pipeline.wayne.edu/  to register for classes, view final grades, send WSU e-mail, work with calendars, download class lists, check pay stubs and vacation balances, and access many other E-Services WSU offers. You need a WSU AccessID to login. Click here to look up for your AccessID. Any other questions about AccessID (including how to activate it) is available here, or you can call Please call the C&IT Help Desk at 313-577-4778 to obtain assistance.  Note that you need to activate before you can use it. 
  • All students who would like to take the course are expected to attend the first class. You cannot take this course if you do not attend the first class. 

Objective

The goal of the course is to present a basic introduction to information systems design including the understanding of the life cycle of an information system and various methods and tools for modeling, designing, and implementing a modern information system. The course will be companied by an in-class lab component, in which students will have hands-on experience under the instructions of the instructor to conduct a step-by-step design and implementation of a simple but comprehensive information system, from architecture design, data modeling, process modeling, to user interface design. After taking this course, you will have the skill of modeling, designing, and developing various business, enterprise, scientific, and medical information systems.

Prerequisites

  • CSC 2200 and CSC4100, or with the permission of the instructor. 

Instructor:

TA's office hours

  • Name:  Seunghan Chang
  • Email: aq9320@wayne.edu
  • Office: 227 State Hall
  • Office hours: TuTh 2:00-3:00PM

Textbook:

  • Database Systems - An Application-Oriented Approach, by Michael Kifer, Arthur Bernstein and Philip M. Lewis, second edition,  ISBN: 0-321-26845-8. Addison-Wesley, 2005. A copy of the text  book is reserved in the science library. You can loan it for 2 hrs at a time.   

Recommended materials:

  • Oracle PL/SQL Programming, 3rd Edition, ISBN 0-596-00381-1, By Steven Feuerstein with Bill Pribyl
    O'Reilly.
  • Systems Analysis and Design, 3rd Edition, by Alan Dennis, Barbara Haley Wixom and Roberta M. Roth, published by John Wiley's & Sons Inc., 2006. SBN: 047172257X.
  • Microsoft® Office Access 2003 Inside Out, John L. Viescas,  ISBN  0-7356-1513-6

Course outline:

A tentative series of lectures are given in the following which is subject to change. The lecture slides are available. More slides will become available as the semester progresses.

 

Course load and grading:

The course will require the following work: 

  • (5%)  Class performance (including attendance, quiz, questions, and answers)
  • (30 %) Two Assignments (tentative due on 10/30 and 11/27, respectively)
  • (35 %) One project, part 1 (10%, tentative due on 10/11), part 2 (10%, tentative due on 11/8), and part 3 (15%, tentative due on 12/11)
  • (30 %) Final exam (tentative 12/18 in class)

All the above work is expected to be done individually except the projects which will be completed by a group of at most two students.

Late work penalty:

You can have one late assignment submission up to one week without any penalty. Please indicate on the cover page of your submission when you use your late excuse. If late excuse is not used, a penalty of 10 % per day will be assessed up to one week. No credits will be given for works handed in one week after the due date.

Academic Honesty:

Copying an assignment from another student in this class or obtaining a solution from some other source will lead to an automatic failure for this course and to a disciplinary action. Allowing another student to copy one's work will be treated as an act of academic dishonesty, leading to the same penalty as copying. You should learn how to protect your data. Failure to do so is also unprofessional and it may expose you to the danger that someone will copy your homework and will submit it as his or her own (see above). In this case, you may be given a score of 0 for the assignment in question (and the other party will get a failure).

 

Students with Disability and Special Need

If you need a special accommodation due to mental or physical disability or other medical reasons, please contact the Educational Accessibility Services (EAS) Office (1600 David Adamany Undergraduate Library) at  phone (313) 577-1851 or at Email eas@wayne.edu  for a registration.