CS 411

CS 411 - Database Systems

Fall 2021

Title	Rubric	Section	CRN	Type	Hours	Times	Days	Location	Instructor
Database Systems	CS411	O3	75725	OLC	3	2100 - 2215	M W		Abdussalam Alawini
Database Systems	CS411	O4	75726	OLC	4	2100 - 2215	M W		Abdussalam Alawini
Database Systems	CS411	Q3	30109	OLC	3	1100 - 1215	M W		Abdussalam Alawini
Database Systems	CS411	Q4	40086	OLC	4	1100 - 1215	M W		Abdussalam Alawini
Database Systems	CS411	R3	67652	LCD	3	1400 - 1515	T R	2035 Campus Instructional Facility	Yongjoo Park
Database Systems	CS411	R4	69827	LCD	4	1400 - 1515	T R	2035 Campus Instructional Facility	Yongjoo Park
Database Systems	CS411	S3	76348	LCD	3	1100 - 1215	M W	2039 Campus Instructional Facility	Abdussalam Alawini
Database Systems	CS411	S4	76349	LCD	4	1100 - 1215	M W	2039 Campus Instructional Facility	Abdussalam Alawini

See full schedule from Course Explorer

Web Page

https://wiki.illinois.edu/wiki/display/CS411AAFA21

Official Description

Examination of the logical organization of databases: the entity-relationship model; the hierarchical, network, and relational data models and their languages. Functional dependencies and normal forms. Design, implementation, and optimization of query languages; security and integrity; concurrency control, and distributed database systems. Course Information: 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.

Course Director

Abdussalam Alhadi M Alawini
Kevin Chenchuan Chang

Text(s)

Database Systems: The Complete Book, 2nd Edition, by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom

Learning Goals

Analyze real-world data management scenarios and design appropriate data schemas (1), (2), (3), (4), (5), (6)
Formulate SQL queries to access a relational database system (1), (2), (5), (6)
Design and develop data management applications using relational database systems (1), (2), (3), (4), (5), (6)
Analyze and apply data indexing techniques for speeding up query processing (1), (2), (5), (6)
Analyze and apply query optimization techniques for optimizing query execution (1), (2), (5), (6)
Analyze and apply transaction processing techniques for executing transactions in relational database systems (1), (2), (5), (6)

Topic List

Data modeling principles and E-R Diagram Techniques
Relational Algebra
SQL Query Language
Data Storage and Indexing
Query Execution and Optimization
Concurrency Control & Failure recovery

Required, Elective, or Selected Elective

Selected Elective.

Last updated

2/14/2019by Abdussalam Alawini