Entities, attributes and E-R diagrams: Tasks

Attributes and entities task

Students are given a number of different entities for various scenarios. They have to identify the appropriate attributes that would be related to those entities.

(subscription only)

download file

task

download file

answers

 

Entity relationships practical workbook

Goes through one-to-one, one-to-many and many-to-many relationships giving students opportunities to practice creating appropriate ERDs.

(subscription only)

download file

workbook

download file

answers

Resolving relationships

This activity provides students with a set of example relationships which are set up as 'many to many'.

Their task is to try to resolve the relationships correctly and in so doing, gain a better understanding of this skill.

Kindly contributed by Julia Stevens

click here

 

Entity Identity

This activity provides a very gentle introduction to entities and ERD.

Kindly contributed by Julia Stevens

click here

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © www.teach-ict.com