CS54100 - Database SystemsFall 2017
Days/Time: TTh / 12:00-1:15 pm
Credit Hours: 3
Provides an introduction to the design and development of relational database management systems (DBMSs).
A number of fundamental DBMS concepts will be covered in the course. You will learn the theory behind database systems, the issues that affect their functionality and performance, and importantly, what it takes to build the engine of a database. Spring 2015 Syllabus
DBMS Concepts and Architecture; Relational Databases, Relational Algebra and Calculus; Query Languages (SQL, QBE); Storage and Indexing; Query Evaluation and Optimization; Database Design, the E-R Model, Normalization, and Tuning; Database Security and Integrity; Transaction Management; Concurrency Control, and Recovery Techniques; Parallel and Distributed Databases.
Knowledge of the Java programming language is essential.
Programming and Homework Assignments 50%. Extra-credit points will be given in class.
The projects are an important part of the course, and will involve a significant amount of Java programming. The first projects will be SQL programming assignments using Oracle. The remaining projects will be performed in teams of two. The purpose is for each team to build parts of a working single-user relational database management system. You will start almost from scratch -- a few basic components may be provided to you. By the end of the course, you will have built a simple DBMS by completing four separate assignments
Mid-term Exam 20%; Final 30%.
Official textbook information is now listed in the Schedule of Classes. NOTE: Textbook information is subject to be changed at any time at the discretion of the faculty member. If you have questions or concerns please contact the academic department.
Tentative: Required Textbook : ISBN: 9780072465631 Database Management Systems, (NOTE: Third Edition), by Raghu Ramakrishnan and J. Gehrke. McGraw Hill, 2003, ISBN 0-07-246563-8.
ProEd Minimum Computer Requirements
ProEd Minimum Requirements: view
Tuition & Fees: view