CSCI-4380 Database Systems (4 CR.)

Description
Discussion of the state of practice in modern database systems with an emphasis on relational systems. Topics include database design, database system architecture, SQL, normalization techniques, storage structures, query processing, concurrency control, recovery, security, and new directions such as object-oriented and distributed database systems. Students gain hands-on experience with commercial database systems and interface building tools. Programming projects are required.

Prerequisites
CSCI-2300 Data Structures

Textbook(s)
Ordering Information

Format
Classes: 6 weeks, 12 sessions (plus 5, 3-hour supplemental sessions)
Project: 1
Exams: 2

Grading
Project 0% (required and will impact borderline grade situation)
Exams 100%

Computing
Email and World Wide Web access required for course communications, use of WebCT, and printing of course notes. Access to Telnet and FTP is also required. ORACLE provided (through Telnet from Rensselaer at Hartford). Students may choose to use any robust relational database management system they have access to (instead of using ORACLE).

Access to WebCT, Rensselaer's course management tool, is required. Please refer to this page for instructions on how to set up your computer for WebCT.

Who Should Enroll
This course may be used in your Plan of Study as follows:

Degree Programs
CSCI - application course
CSYS - technical elective
ELEC - technical elective
EPOW - technical elective
ESCI-MOT - elective with advisor pre-approval
ESCI-MSE - elective with advisor pre-approval
ITEC - required core course
MANE - elective with advisor pre-approval
MBA - elective with advisor pre-approval
MGMT-MS - elective with advisor pre-approval
MGTE - elective with advisor pre-approval
TCOM - n/a

This course is also open to non-matriculated students who meet the prerequisites and is required for the Certificate in Database Systems Design. It may also be used toward the Certificates in Computer Science and Information Technology.

NOTE: Limited enrollment, please register early. Distance students will not be added into the course once the cap has been met. Preference will be given to graduating students.