Identify a set of information that you would like to track using a database. One example would be a collection of video games.

Identify the entities involved in this collection.

For example the games collection might have the following entities:

CONSOLE, PUBLISHER, GAME, RATING, GENRE

For each entity, identify the attributes you want to track.

For example, the Game entity might have the attributes:

GAME$\_$ID$,$ NAME, DESCRIPTION, CONSOLE$\_$ID$,$ PUBLISHER$\_$ID$,$ RATING$\_$ID$,$ GENRE$\_$ID

List each of the Relations in shorthand notation and underlining the primary key of the relation.

For example the GAME relation would be:

GAME$($GAME$\_$ID$,$ NAME, DESCRIPTION, CONSOLE$\_$ID$,$ PUBLISHER$\_$ID$,$ RATING$\_$ID$,$ GENRE$\_$ID$)$