50 likes | 54 Views
COMP3311: Database Systems. Revision & Final Exam. Part1: Database Design. Data Models: Conceptual Model: ODL, ER Relational Data Model Mapping from ER to Relational Data Model. Database Language Relational Algebra SQL/PLSQL (PLSQL will not be tested). Part1: Database Design.
E N D
COMP3311: Database Systems Revision & Final Exam COMP3311 Database Systems
Part1: Database Design • Data Models: • Conceptual Model: ODL, ER • Relational Data Model • Mapping from ER to Relational Data Model. • Database Language • Relational Algebra • SQL/PLSQL (PLSQL will not be tested) COMP3311 Database Systems
Part1: Database Design • Relational Database Design • Functional Dependency • Normal Forms • BCNF algorithms, 3NF algorithms, etc • Data Quality • Data Clean framework, issues • FD & IND, Repair Framework • CFD & CIND, SQL to Detect Conflicts (Violations) • Algorithm and complexity details will not be tested. COMP3311 Database Systems
Part2: DBMS • Physical Database Design • Storage, Buffer Management • Indexing • Transaction Management • Recovery framework • ACID • Schedule: serial serializability • Concurrency control (2 phase locking, time ordering) COMP3311 Database Systems
Final Exam • 6 Questions, each has several subquestions • Q1: yes/no. penalty to wrong answer. Mark distribution: • 15 for Q1 • Data model: 15 • Relational DB design and Relational Algebra: 22 • Physical DB design: 16 • Transaction Management: 16 • Data Quality: 16 COMP3311 Database Systems