ISDD+Entity+Relationship+Diagrams

media type="custom" key="28094119"


 * Questions**

1. Games Sales A computer games uses a relational database to store the 4 tables shown below.

(a) Draw an entity relationship diagram to represent the relationships between the tables (b) Suggest a suitable primary key for the Sale table

2. Vets A veterinary practices uses a relational database to store the 5 tables shown below.

(a) Draw an entity relationship diagram to represent the relationships between the tables (b) Suggest a suitable primary key for the Appointment table

3. Conference Centre A conference centre has 5 halls: one large hall for concerts, 2 medium halls for trade shows and 2 small halls for meetings. The conference centre has 2 managers who manage bookings for each hall Bookings can be taken for either a day, or half a day and details are noted about the number of attendees

Draw an entity relationship diagram to represent this model

4. Exams A school are holding their prelim exams for the following subjects: Higher Computing (2 hours) Higher Maths (2 hours) Higher English (2 hours) Nat 5 Computing (1 hour) Nat 5 Physics (1 hour)

Each exam has 3 invigilators, and contact details are stored about each invigilator There will be between 10 and 50 students sitting each exam, and student details including SCN and DOB are stored for each student Each exam is allocated a location (Hall, classroom 2 or classroom 3) and data is stored about the number of tables and clocks in each place

Draw an entity relationship diagram to represent this model