Review of the First Seven Chapters:
(Note: This review is based on the Second Edition of Elmasri/Navathe)
Chapter 1: What is a database (p2), system environment (p3),
characteristics (1.3).
Chapter 2: Data models (2.1.1), schemas (2.1.2), three-schema architecture (Fig. 2.2, p. 27),
DDL, DML (p.29), interfaces (p.30), classification of DBMS (2.5).
Chapter 3: Phases of database design (Fig. 3.1, p. 41),
ER model concepts (3.3), weak entity types (3.3.4), notation for
ER diagrams (3.4), the (min,max) notation and the M:N notation (p.57-58).
Chapter 4: Record blocking (4.4.3), hashing techniques (4.8),
overflow handling (Fig. 4.10, p91 and notes), dynamic hashing (4.8.3),
extendible hashing (4.8.3).
Chapter 5: Primary index (5.1.1), secondary index (5.1.3),
dense and nondense index (5.1), B-tree and B+ tree (5.3),
B+ tree insertion (Fig. 5.12, p. 127).
Chapter 6: Relational model and relational algebra, whole chapter is important,
notice 6.8 explains ER-to-Relational mapping, study the example
from Fig. 3.16(a) to Fig. 6.19 (p. 175).
Chapter 7: SQL, whole chapter is important