About CS 204 A

Techniques for processing very large collections of data. Secondary storage. Database design and management. Query languages and optimization. Database recovery. Prerequisite: CS 124.


Prereqs enforced by the system: CS 124

Section Description

Theory and practice of database design and application programming, and basic internals of a database management system. Specific topics include database concepts, data models and database design, query languages, database programming concepts and languages, files and physical design, query processing and optimization, transaction concepts, concurrency control and recovery, and access control.

Section Expectation

Lecture course. 6 to 8 hours of work expected outside the classroom. Prerequisite: CS124 (required); CS121 (recommended). Required text: Ramez Elmasri and Sham Navathe, Fundamentals of Database Systems (7th edition), Pearson, 2016.


Weekly homework, including written and programming. Exams.

Course Dates



Marsh Life Sci 105 (View Campus Map)


to on Monday, Wednesday and Friday

Important Dates

Note: These dates may not be accurate for select courses during the Summer Session.

Courses may be cancelled due to low enrollment. Show your interest by enrolling.

Last Day to Add
Last Day to Drop
Last Day to Withdraw with 50% Refund
Last Day to Withdraw with 25% Refund
Last Day to Withdraw


    There are no courses that meet this criteria.