CSE 412/598 Fall2000
Semester Syllabus
http://cse.asu.edu/~cse412/
PROFESSOR: Dr. Susan D. Urban
OFFICE: GWC 372
OFFICE HOURS: Mon 2:00-3:00,
Tu 9:15-10:15, Th 9:15-10:15
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-2784
EMAIL: s.urban@asu.edu
CLASS SCHEDULE: TuTh 1:40-2:55
ECG 319
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, Benjamin/Cummings Publishing, Third Edition,
2000.
OPTIONAL TEXT FOR PROJECT:
There are many books available
on Access 7.0. 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,
H. Korth and A. Silberschatz, McGraw Hill.
Principles of Database Systems,
J. Ullman, Computer Society Press.
An Introduction to Database
Systems, C. J. Date, Addison Wesley.
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
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, instructors, 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
conservations.
MISCELLANEOUS NOTES:
-
No audit registrations allowed
-
Students are responsible for protecting their work
- both hard copy (save old copies) and electronic versions (use security
provided by operating system).
-
This syllabus represents the current status of the
course and may be changed.
ACADEMIC INTEGRITY
POLICY
PREREQUISITE SATISFACTION
INFORMATION FOR TEAM
ORGANIZATION
