15-415 Database Applications

Units: 12.0 Department: Computer Science Prerequisites: 15-212 Related URLs: http://www.csd.cs.cmu.edu This course covers the fundamental topics for Database Management Systems: Database System Architectural Principles (ACID properties; data abstraction; external, conceptual, and internal schemata; data independence; data definition and data manipulation languages), Data models (entity-relationship and relational data models; data structures, integrity constraints, and operations for each data model; relational query languages: SQL, algebra, calculus), Theory of database design (functional dependencies; normal forms; dependency preservation; information loss), Query Optimization (equivalence of expressions, algebraic manipulation; optimization of selections and joins), Storage Strategies (indices, B-trees, hashing), Query Processing (execution of sort, join, and aggregation operators), and Transaction Processing (recovery and concurrency control).

Popularity index Rank for this semester: #95 Rank in this department: #14   Students also scheduled 15-451 Algorithm Design and Analysis 15-213 Introduction to Computer Systems 15-390 Special Topic: Entrepreneurship for... 21-257 Models and Methods for Optimization 70-122 Introduction to Accounting 21-301 Combinatorics 67-271 Fundamentals of System Development ... 15-397 Special Topic: Web Application Deve... 98-037 Student Taught Courses (StuCo): Int... 67-272 Application Design and Development

Spring 2005 times

Sec	Time	Day	Instructor	Location
1	1:30 - 2:50 pm	T	Olston	HH B103
		R	Olston	HH B103
A	9:30 - 10:20 am	W	Instructor TBA	SH 220
B	10:30 - 11:20 am	W	Instructor TBA	SH 220
C	11:30 am - 12:20 pm	W	Instructor TBA	SH 220