CS 348: Introduction to Database Management

Fall 2012

Course Notes

• Introduction to the course
• Overview of database management
• Conceptual modeling: Entity-Relationship modelling
• Relational data model
• Relational algebra
• Relational calculus
• Logical modeling: ER-to-relational mapping
• Introduction to SQL
• Advanced SQL: writing applications
• Transactions & transaction support in SQL
• Views and view management
• Schema refinement and normalization
• Physical design and tuning
• Database security and privacy
• Parallel and distributed DBMSs
• Data warehousing

The lecture notes are complementary to the textbook; they are not meant to replace the textbook. You are expected to know both the material in the textbook for the assigned sections, and the material in the course notes.