Database System Lectures

(Click to Download Slides)

• Lecture 1: introduction. What is a database management system.
  Lecture 1, pdf 6 slides to a page 
  Lecture 1 ppt
• Lecture 2: relational algebra.
  Lecture 2, pdf 6 slides to a page 
  Lecture 2 ppt
• Lecture 3: relational data integrity.
  Lecture 3, pdf 6 slides to a page 
  Lecture 3 ppt
• Lecture 4: Entity-relationship modelling.
  Lecture 4, pdf 6 slides to a page 
  Lecture 4 ppt
• Lecture 5: From ER diagrams to tables; creating database tables in SQL.
  Lecture 5, pdf 6 slides to a page 
  Lecture 5 ppt
• Lecture 6: Changing tables, inserting tuples; SELECT statements.
  Lecture 6, pdf 6 slides to a page 
  Lecture 6 ppt
• Lecture 7: SELECT statements.
  Lecture 7, pdf 6 slides to a page 
  Lecture 7 ppt
• Lecture 8: more SELECT; nested queries.
  Lecture 8, pdf 6 slides to a page 
  Lecture 8 ppt
• Lecture 9: more SELECT; order by, group by, having.
  Lecture 9, pdf 6 slides to a page 
  Lecture 9 ppt
• Lecture 10: NULLs.
  Lecture 10, pdf 6 slides to a page 
  Lecture 10, ppt
• Lecture 11: Normalisation (1NF, 2NF,3NF).
  Lecture 11, ppt
• Lecture 12: Relational algebra revision, lossless decomposition, BCNF
  Lecture 12, pdf 6 slides to a page 
  Lecture 12 ppt
• Lecture 13: Physical DB issues, indexing, query optimisation.
  Lecture 13 ppt
• Lecture 14: Transactions and recovery.
  Lecture 14, pdf 6 slides to a page 
  Lecture 14 ppt
• Lecture 15: Concurrency control: using locks.
  Lecture 15, pdf 6 slides to a page 
  Lecture 15 ppt
• Lecture 16: Deadlock. Timestamping protocol.
  Lecture 16, pdf 6 slides to a page 
  Lecture 16 ppt
• Lecture 17: Security and Integrity.
  Lecture 17, pdf 6 slides to a page 
  Lecture 17 ppt
• Lecture 18: `Modern' datatbases.
  Lecture 18 ppt  
  Lecture 18 pdf one slide to a page 
• Lecture 19: Revision.
  Lecture 19 pdf one slide to a page
• Lecture 20: Java and SQL.
  Lecture 20 pdf one slide to a page