‑‑WAYNE STATE UNIVERSITY

MAIN CAMPUS

INFORMATION SYSTEMS DESIGN  - CSC471 (3 CR)

 

LECTURER:              Joseph D. Ramsey

OFFICE:                         462 State Hall

OFFICE HOURS:            Tuesday and Thursday, 6:00 - 7:00 p.m.

E-mail:                                    ramsey@dwsd.org

xxxx@cs.wayne.edu

 

START DATE:      January 15            QUARTER:      Winter

DAYS:                  Tuesday and Thursday      TIME:            7:30 - 8:50 p.m.      ROOM:  37 State Hall

TEXT:                        DATABASE PROCESSING , David M. Kroenke, Sixth Edition - ISBN 0137572387

ACCESS ‘97 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

·            Hierarchical and Network Data Models

·            Introduction to Building XML Applications

ü    Three (3) tier  model  using 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 6 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 commands under ORACLE.

 

Assignment #                       Assignment Date                                                Due Date

1                                                    Jan. 14                                                                Jan. 21

2                                                    Jan. 28                                                                Feb. 04

3                                                    Feb. 11                                                                Feb. 18

4                                                    Feb. 25                                                                Mar. 04

5                                                    Mar. 25                                                                Apr. 06

6                                                    Apr. 15                                                                Apr. 22

 

 

 

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, Mar. 11

Final         Thursday, Apr. 29

 

 

SCHEDULE (PROJECT):

Activity                                                                                                                 Suggested Completion

E-R/Semantic Data Models (20%)                                                                Feb. 25, 2000/Mar. 2, 2000

Map to Relational Model/Normalize Relations (20%)                               Mar. 18, 2000/Mar. 23, 2000

Form, Query, and Menu Designs (20%)                                                Apr. 08, 2000/Apr. 12, 2000

Project Implemented and Delivered (40%)                                                Apr. 27, 2000/Apr.  29, 2000

 

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:      

A- :    88% - 91%

B+:    85% -     87%

B- :    82%

1�        :  78% - 81%

C+:   75% - 77%

C  :    72% - 74%

2�        :  68% - 71%

D+:   65% - 67 %

D  :    62% - 64%

3�        :  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.