v CPSC 437/537: Database Systems (Fall 2022)

CPSC 437/537: Database Systems (Fall 2022)

Time: TTh, 9:00am - 10:15am
Location: WLH 119 - William L. Harkness Hall 119

Instructor: Avi Silberschatz (AKW 308, avi@yale.edu)
Office Hours: By appointment

TA: Ferhat Erata (AKW 203, ferhat.erata@yale.edu)
Office Hours: Thursday, 1 PM to 2 PM
Zoom: https://yale.zoom.us/my/ferhat

TA: Tong Cheng (AKW 305, tong.cheng@yale.edu)
Office Hours: Monday, 3 PM to 4 PM
Zoom: https://yale.zoom.us/my/tongcheng

TA: Jane Lee (17 Hillhouse 333, jane.h.lee@yale.edu)
Office Hours: Friday 9:30 AM to 10:30 AM
Zoom: https://yale.zoom.us/my/janehjlee

TA: Grigoris Velegka (17 Hillhouse 321, Grigoris.velegkas@yale.edu)
Office Hours: Wednesday 5:30 PM to 6:30 PM
Zoom: https://yale.zoom.us/j/98012270667

TA: Yanpeng Yu (AKW 208, yanpeng.yu@yale.edu)
Office Hours: Tuesday 11:30 AM to 12:30 PM
Zoom: https://yale.zoom.us/j/8699863625

Textbook: Database System Concepts, Seventh Edition.
The textbook is required

Course description: Database management has evolved from a specialized computer application to a central component of virtually all enterprises, and, as a result, knowledge about database systems has become an essential part of an education in computer science. In this course, we present the fundamental concepts of database management. These concepts include aspects of database design, database languages, and database-system implementation.

The material is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate, level. In addition to basic material for a first course, the course covers advanced material that can be used for course supplements, or as introductory material for an advanced course.

Syllabus: An introduction to database systems. Data modeling. The relational model and the SQL query language. Relational database design, integrity constraints, functional dependencies, and normal forms. Implementation of databases: file structures, indexing, query processing, transactions, concurrency control, recovery systems, and security.

Assignments: There will be some reading assignments from the textbooks. The reading material will be used in some of the homworks but will not be used in the tests. There will be a large project, 4 homework assignments and 2 tests