Title slide
Slides : Recording

In today’s lecture I started to present the topic of structured data with an introduction to Entity-Relationship Modelling and the graphical language of ER diagrams. This language is important for planning and structuring databases, bridging the gap between informal conceptual design and the logical precision required for machine implementation.

I was also able to demonstrate the marvels of recursion by live-streaming the lecture within itself. Fun, but perhaps we won’t do that again.

As usual you can download the lecture slides at the link below, or by clicking on the thumbnail picture of the title slide above. You can also pick up a printed copy from outside the ITO.

Links: Slides for Lecture 2; Recording of Lecture 2

Homework
1. Read This

Sections 2.1–2.4 of this textbook on databases:

R. Ramakrishnan and J. Gehrke. Database Management Systems. Third Edition, McGraw-Hill, 2003.

You can pick up a printed copy of the whole chapter at the ITO. I shall also send all student a PDF by email.

2. Do This

Step inside the library, locate the HUB and find this book. Have a look at the other textbooks there, too, and compare style and content.

Find the video of this lecture online and watch the first minute. If you have any problems then read the blog for recommendations, or ask on Piazza/Facebook.

Extra

Picture of Dr WingWatch this interview with Jeanette Wing. It’s around 30min long and easy to take in. Professor Wing talks to Microsoft’s Channel 9 about her research and ideas about computational thinking.

Links: Video in Microsoft’s “Research Luminaries” series; Copy on Youtube.

Lecture 2: Entities and Relationships