Book Readings

The course content can be studied within the following book chapters (on either main or alternative textbook):

Intro to Databases

• Chapter 1 : Databases and Database Users
• Chapter 2 : Database System Concepts and Architecture
• OR chapter 1 from Silberschatz book

Relational Model

• chapters 5 and 8 (up until 8.5) of the main course textbook.
• OR chapter 2 from Silberschatz textbook

SQL - The Structured Query Language

• chapters 6 and 7 from the main textbook or
• (or chapter 3 and 4 (excluding 4.3, 4.6, 4.7) from the alternative (Silberschatz) textbook).
• Optional readings (relational calculus) include:
• chapters 8.6 and 8.7 from the main textbook 
• OR chapter 27 (excluding 27.4) from Silberschatz textbook 

Normalization

• chapters 14 and 15.1-15.2 from the main textbook
• Or chapters 7-7.5 from the alternative textbook.

Data Storage

• main textbook : chapter 16
• Or chapters 12-13 from Silberschatz book

Transaction Management

• Chapters 20 and 21.1
• Chapter 17, 18.1, 18.2 from Silberschatz book

Database Indexing

• chapter 17 and 16.8 in the main textbook 
• or 14.1-14.8 from Silberschatz textbook.

Query Optimisation

• chapters 18 and 19.1 of the main textbook 
• or chapters 15 and 16.1-16.2  from Silberschatz book