WAYNE STATE UNIVERSITY

MAIN CAMPUS

INFORMATION SYSTEMS DESIGN - CSC471 (3 CR)

LECTURER: Joseph D. Ramsey

OFFICE: 462 State Hall

OFFICE HRS: Tuesday and Thursday, 6:00 – 6:30 p.m.

E-mail: ramsey@cs.wayne.edu

START DATE: January 09 QUARTER: Winter 2003

DAYS: Tuesday and Thursday TIME: 4:30-5:50PM

ROOM: 111 State Hall

TEXT: DATABASE PROCESSING, David M. Kroenke, 8th Edition

OPTIONAL: ACCESS 2000 BIBLE, Prague and Irwin

COURSE OBJECTIVES

The overall goal of this course is to provide the student with a basic knowledge of the fundamentals, design and use of databases in meeting business information needs.

UPON COMPLETION OF THIS, THE STUDENT WILL:

• Gain insight into the field of database systems
• Understand the nature of database processing
• Apply an integrated perspective to database design
• Understand the stages of database design practices within the scope of information systems

COURSE TOPICS (SUMMARY):

• Data modeling
• Relational database design
• Structured Query Language (SQL)
• Normalization techniques
• Relational database implementation
• Relational database implementation using Access 2000, Oracle or MySQL
• Hierarchical and Network Data Models
• Introduction to Building XML Applications
• Three (3) tier model using a browser, XML and backend database
• XML and Relational Databases
• Processing XML on a Server
• XML and file system
• XML and Java in developing future Web Application
• Why XML will affect your future in information Technology

The pace of the class will determine the actual schedule. Additional topics may be added if time permits.

SCHEDULE (HOMEWORK ASSIGNMENTS):

There will be 5 assignments, due at the beginning of the lecture period of the due date.

NO LATE ASSIGNMENTS WILL BE ACCEPTED, AND A FAILING GRADE WILL BE POSSIBLE TO ANYONE TURNING IN 50% OR LESS OF THEIR HOMEWORK ASSIGNMENTS.

One or more of the assignments may involve using SQL to implement relational operations such as SELECT, PROJECT, PRODUCT, UNION, INTERSECT, MINUS, JOIN, OUTER JOIN(S), and other SQL*PLUS.

Assignments Assignment Date Due Date

1 Jan. 16 Jan. 21

2 Jan. 30 Feb. 04

3 Feb. 14 Feb. 18

4 Mar. 06 Mar. 11

5 Mar. 27 Apr. 01

SCHEDULE (EXAMINATION):

There will be a midterm and a final. The midterm will be based on the material covered to that point and date for the midterm. The exams will be closed--NO BOOKS, NOTES, OR NEIGHBORS.

Midterm Thursday, Feb. 27

Final Tuesday, Apr. 03

SCHEDULE (PROJECT):

Activity Suggested Completion

E-R/Semantic Data Models (20%) Jan. 30

Map to Relational Model/Normalize Relations (20%) Feb. 20

Form, Query, and Menu Designs (20%) Mar. 13

Project Implemented and Delivered (40%) Mar. 27

THE FINAL WILL BE CALCULATED AS FOLLOWS:

Average of Homework 20%

Midterm 20%

Final 30%

Project 30%

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 PROJECTS.