Data Modelling and Databases Lectures/Exercises

Lectures

 

 # Topic
 Slides
1. Introduction [pdf]
2. Entity-Relationship (ER) Model [pdf]
3. Relational Model [pdf]
4a. SQL I. [pdf]
4a. SQL examples [pdf] [sql]
4b. SQL II. [pdf]
5. Integrity Constraints [pdf] [sql]
6. Functional Dependencies [pdf]
7. Normal forms [pdf]
8. Schemas [pdf] [pivot chart]
9. Database Internals  [pdf]
10. Query Processing  [pdf]
11. Query Optimization  [pdf]
12. Transactions  [pdf]
13. Two Phase Commit  [pdf]
14. Replication  [pdf]
15. Key-value Stores  [pdf]
16. Security  [pdf]
17. New hardware  [pdf]

 

Exercises

Date (Solve by) Topic Handouts Slides Solution
February 23rd/26th No exercise      
March 1st/4th Entity-Relationship Model  [Ex-1] [Slides-1] [Solution-1]
March 8th/11th Relational Model  [Ex-2] [Slides-2]  [Solution-2]
March 15th/18th Relational Algebra  [Ex-3] [Slides-3]  [Solution-3]
March 22nd Database Setup

 [Ex-4]

 [Ubuntu Tutorial]

 [MacOS Tutorial]

 [Windows Tutorial]

 [Datasets]

   
April 5th/8th SQL  [Ex-5  [Slides-5]  [Solution-5]
April 12th/15th SQL II  [Ex-6]  [Slides-6]  [Solution-6]
April 19th/22nd Integrity Constraints

 [Ex-7] [SQL]

 [Slides-7]  [Solution-7]
April 26th/29th Normal Forms I  [Ex-8]  [Slides-8]  [Solution-8]
May 3rd/6th Normal Forms II  [Ex-9]  [Slides-9]  [Solution-9]
May 10th/13th  Query Processing & Query Optimization  [Ex-10]  [Slides-10]  [Solution-10]
May 17th/20th  Transactions  [Ex-11]  [Slides-11]  [Solution-11]
May 24th/27th  Two Phase Commit & Replication  [Ex-12]  [Slides-12]  [Solution-12]
May 31st/June 3rd  Q&A -- Send us questions!    [Slides-13]