Lecture 2: Entities and Relationships

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.

Viewing Lecture Recordings

Feedback from students suggests that viewing lecture recordings isn’t quite as one-click as I had hoped. While I included direct links in the previous blog post and on Piazza, those only work once you have been recognised as an authorized Inf1-DA student by Echo360 who provide the lecture recording service.

If you find that the links don’t work for you then I recommend you do the following.

  • Connect to Learn at https://www.learn.ed.ac.uk.
  • Log on through EASE if necessary.
  • Select Informatics 1 – Data and Analysis (2017-2018)[SV1-SEM2].
  • Select the Lecture Recordings link on the left-hand side.
  • That will attempt to pop-up a new window. Your browser may disallow this — mine did — in which case you can wait a moment until Learn realises that and then select the button offered to open Media Hopper Replay in a new window.

I believe that once you have trodden this path all parties involved will recognise you as a legitimate Inf1-DA student. The one-click links I post here should then work directly.

If you find a simpler method to do this then please let me know.

If you try this and still can’t see the lecture recording, then please let me know.

If you can’t give me a URL to get to it, then it isn’t on the Web.