Database Systems Week 3

Materials for this week

  • Writing RA and SQL for dummies
  • Other RA operations – Union, Set Difference, Intersection and Division
  • DQL, DDL and DML

Connolly & Begg (4th ed.) Chapter 5 and 6 has sections on Data Manipulation and Data Definition. Chapter 4 has material on relational algebra (material on relational calculus isn’t required). Note that a more detailed explanation of division is offered here which may be useful later.

Ramakrishnan & Gehrke (Database Management Systems) has an excellent chapter on relational algebra, as has Elmasri & Navathe (Fundamentals of Database Systems).

Slides and lab materials based on Access can be found here

  • Problems in the relational model
  • Last part of SQL: function, grouping and subqueries

Slides and lab materials based on Access can be found here

Connolly & Begg for complete sets of DDL/DML/DQL SQL examples (Chapter 6 in 4th ed.). The other two books also have coverage.

Database Systems Week 2

Materials for this week

Lecture notes and exercises on Join, outer joins / inner joins

Notes on views in Relational DB and views in SQL

Article on query optimisation

Homework question РQ.4 (a) Р(c) only  query tree example

Connolly, T., Begg, C., 2010, Database Systems, 5th Ed.: Chapter 4 – Views, Chapter 5 – Relational Algebra, Chapter 6 – SQL Data Manipulation

Elmasri, R., Navathe, S., Database Systems, 6th Ed.: Chapter 18, pp. 680-690, Query Tree Heuristics

Silbershatz, A., Korth, H., Sudarshan, S., Database System Concepts, 6th Ed.: Chapter 13, pp. 579-589, Query Optimization