understand the basics of query processing and optimization, concurrency controls and database recovery. gain work experience in a lab project as a team member or leader. Textbook by Ramez Elmasri and Shamkant Navathe, Addison Wesley, 5th Edition, 2007. Fundamentals of Database Systems, Course Outline (Tentative) # Of Main Topic Sub-Topic Chapter Lectures Databases and Database Users [1] 2 Introduction Database Systems Concepts and Architecture [2] 3 5 Entity-Relationship Model [3] 3 Enhanced Entity-Relationship Model [4] 2 Data Models The Relational Data Model [5] 2 ER and EER Mapping [7] 2 9 Relational Algebra [6.1 6.5] 4 – Relational Relational Calculus [6.6 6.7] 2 – Database SQL [8] 6 Languages 12 Functional Dependencies and Normalization [10] 3 Practical Database Design [12.1,12.2] 1 [13.3 13.7] – Database Design File Organization 3 [14.1 14.3] – Physical Database Design and Tuning [16] 1 8 Query Processing & Optimization [15.1, 15.7] 2 System Transaction Processing [17.1 17.3] 1.5 – Implementation Concurrency Control [18.1, 18.2] 1.5 Techniques Database Recovery [19.1] 1 6 Total Number of Lectures 40
understand the basics of query processing and optimization, concurrency controls and database recovery. gain work experience in a lab project as a team member or leader. Textbook Fundamentals of Database Systems, by Ramez Elmasri and Shamkant Navathe, Addison Wesley, 5th Edition, 2007. Course Outline (Tentative) Main Topic Sub-Topic Chapter # Of Lectures Introduction Databases and Database Users [1] 2 Database Systems Concepts and Architecture [2] 3 5 Data Models Entity-Relationship Model [3] 3 Enhanced Entity-Relationship Model [4] 2 The Relational Data Model [5] 2 ER and EER Mapping [7] 2 9 Relational Database Languages Relational Algebra [6.1 – 6.5] 4 Relational Calculus [6.6 – 6.7] 2 SQL [8] 6 12 Database Design Functional Dependencies and Normalization [10] 3 Practical Database Design [12.1,12.2] 1 File Organization [13.3 – 13.7] 3 [14.1 – 14.3] Physical Database Design and Tuning [16] 1 8 System Implementation Techniques Query Processing & Optimization [15.1, 15.7] 2 Transaction Processing [17.1 – 17.3] 1.5 Concurrency Control [18.1, 18.2] 1.5 Database Recovery [19.1] 1 6 Total Number of Lectures 40
092_cosc406-Syllabus.docx