WAYNE STATE UNIVERSITY

WAYNE STATE UNIVERSITY

MAIN CAMPUS

DESIGN OF INTELLIGENT SYSTEMS - 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: September 04 QUARTER: Fall 2001

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

ROOM: 129 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.

Assignment# Assignment Date Due Date

1 Sept. 11 Sept. 18

2 Sept. 25 Oct. 02

3 Oct. 09 Oct. 23

4 Nov. 13 Nov. 20

5 Nov. 27 Dec. 04

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, Oct. 25

Final Thursday, Nov. 29

SCHEDULE (PROJECT):

Activity Suggested Completion

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

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

Form, Query, and Menu Designs (20%) Nov. 15

Project Implemented and Delivered (40%) Nov. 29

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.