Worksheet 2 Database concepts
Unit 4 Exchanging data
Worksheet 2 Database concepts
Task 1: Entity relationship diagrams
1. What is an entity in the context of databases?
2. The relationship between two entities may be one of three types, or degrees.
What are the three degrees of relationship between entities?
3. Draw entity relationship diagrams for each of the following pairs of related entities:
(a) Dentist and patient
(b) Student and teacher
(c) UK citizen and UK Passport
(d) Product and component
1
Unit 4 Exchanging data
Worksheet 2 Database concepts
Task 1: Entity relationship diagrams
1. What is an entity in the context of databases?
2. The relationship between two entities may be one of three types, or degrees.
What are the three degrees of relationship between entities?
3. Draw entity relationship diagrams for each of the following pairs of related entities:
(a) Dentist and patient
(b) Student and teacher
(c) UK citizen and UK Passport
(d) Product and component
1
