Erd Question

Informatics 1 Data & Analysis Tutorial 1 Tutor Notes

Week 3, Semester 2, 2013–2014

This worksheet has three parts: tutorial Questions, followed by some Examples and their Solutions. • Before your tutorial, work through and attempt all of the Questions in the first section. • The Examples are there for additional preparation, practice, and revision. • Use the Solutions to check your answers, and read about possible alternatives. You must bring your answers to the main questions along to your tutorial. You will need to be able to show these to your tutor, and may be exchanging them with other students, so it is best to have them printed out on paper. If you cannot do some questions, write down what it is that you find challenging and use this to ask your tutor in the meeting. Tutorials will not usually cover the Examples, but if you have any questions about those then write them down and ask your tutor, or go along to InfBASE during the week. It’s important both for your learning and other students in the group that you come to tutorials properly prepared. If you have not attempted the main tutorial questions, then you may be sent away from the tutorial to do them elsewhere. Data & Analysis tutorials are not formally assessed, but they are a compulsory and important part of the course. If you do not do the exercises then you are unlikely to pass the exam. Attendance at tutorials is obligatory: if you are ill or otherwise unable to attend one week then email your tutor, and if possible attend another tutorial group in the same week. Please send any corrections and suggestions to Ian.Stark@ed.ac.uk

Introduction

In this tutorial you are required to design an Entity Relationship Model for a database to be used by the organisers of a poster exhibition in order to keep track of three phases in the exhibition: submission, selection and presentation. You should read the scenario carefully, making a note of all the candidate entities you think are involved, and of...