CSE 412/598 Spring 2000
Semester Syllabus
http://www.eas.asu.edu/~cse412/




PROFESSOR: Dr. Suzanne Dietrich

OFFICE: GWC 368

OFFICE HOURS: Tue: 10:45-11:45am Wed: 1:00- 2:00pm Thu: 2:00-3:00pm
A student should make every effort to utilize the scheduled office hours. However, if you are unable to attend these office hours, please schedule an appointment at least 24 hours in advance.
PHONE: 965-2786

EMAIL: dietrich@asu.edu

CLASS SCHEDULE: TuTh 9:15-10:30 LSA A163

PREREQUISITE: CSE 310 (Data Structures)

Each student must satisfy the prerequisite and submit proof of prerequisite on the first day of class. REQUIRED TEXT: Fundamentals of Database Systems, R. Elmasri and S. B. Navathe, Addison Wesley, Third Edition, 2000. OPTIONAL TEXT FOR PROJECT: There are many books available on Access. Since students differ in the type of information that they are looking for from a book (tutorial, overview, in-depth), an optional text has not been ordered this semester. ADDITIONAL REFERENCES: Database Systems Concepts, A. Silberschatz, H. Korth and S. Sudarshan, McGraw Hill. An Introduction to Database Systems, R. Ramakrishnan and J. Gehrke, McGraw Hill An Introduction to Database Systems, C. J. Date, Addison Wesley. A First Course in Database Systems, J. Ullman and J. Widom, Prentice-Hall

OBJECTIVES OF THE COURSE:

This course is intended to give students an understanding of data modeling concepts as well as an introduction to database theory and database systems organization.

COURSE OUTLINE:

Introduction: Ch 1, 2

Database Design: Ch 16

Entity-Relationship Model: Ch 3

Relational Model and Relational Algebra: Ch 7

ER-to-Relational Mapping: Ch 9

Query Processing and Optimization: Ch 18

Relational Database Design: Ch 14, 15

Relational Calculus: Ch 9

SQL: Ch 8

System Catalog: Ch 17

Transactions, Recovery and Concurrency: Ch 19, 20, 21

Security and Authorization: Ch 22

GRADING:

20 %

Midterm Exam

A >= 90

30 %

Comprehensive Final Exam

90 > B >= 80

15 %

WinRDBI Homework Assignments (3@5% each)

80 > C >= 70

35 %
---------

Team Project

70 > D >= 60

60 > E

100 %

Total

LATE ASSIGNMENTS ARE NOT ACCEPTED!

WinRDBI individual homework assignments and the different phase deliverables of the team project will be turned in at the beginning of class on each due date. WinRDBI assignments will be submitted through the web before the start of class and solutions to the WinRDBI assignments will be posted on the web at the start of class. MAKE-UP EXAMS ARE NOT GIVEN! Students are responsible for making every effort to take exams at the scheduled class time and day.

TEAM PROJECT:

The team project in CSE 412/598 involves the development of a database application using the Microsoft Access relational database system. The incorporation of the semester-long team project into the course is part of a funded grant that was received by Dr. Suzanne Dietrich and Dr. Susan Urban from the National Science Foundation for the purpose of incorporating cooperative learning concepts and hands-on database experience into the undergraduate educational process. The project is also designed to allow students to experience different leadership roles and to develop communication skills, in addition to the development of technical knowledge about database systems. The project is divided into three major phases.Teams will be formed and phase 1 of the project will begin by the second week of the semester. Students that drop after teams are formed will receive a grade of E in the course.

EFFECTIVE COMMUNICATION:

As a computing professional who must effectively work together with others, you are expected to use appropriate language (written or oral) to communicate your ideas. Inappropriate language includes profanity as well as words that are biased or slanted (racially, sexually, ethnically, etc.). You should try to understand another person's point of view and anticipate what they might feel is inappropriate. In CSE 412, you are expected to use appropriate language in all written assignments and in all written and oral communication with peers, instruc tors, and teaching assistants. Use of inappropriate language will result in your withdrawal from the class.

CLASSROOM BEHAVIOR AND PARTICIPATION:

Due to the group project and in-class group study problems, class participation is strongly encouraged. Points will be deducted from an individual’s grade on the phases of the group project for lack of participation in in-class group activities. Students are also expected to come to each class on time and avoid disruptive side conversations.

MISCELLANEOUS NOTES:

ACADEMIC INTEGRITY POLICY

PREREQUISITE SATISFACTION

INFORMATION FOR TEAM ORGANIZATION