Data Model: World Cup 2018

The aim of this book is to explain, using a data model, how FIFA World Cup tournament data can be used to produce a set of searchable records to document the outcomes of the games played. This will be done by the linking of individual items of information (data) about an entity, e.g. the names of teams, with other items of information e.g. number of games played, goals scored etc. The data of interest are that which enable the deduction of the result of each game. To explain how databases may be constructed in accordance with the data model, I shall work through the creation and population of a database that can be used to document the FIFA World Cup 2018 tournament to be held in Russia. The intention is to use a method that is simple, rigorous and repeatable. The techniques employed and the models discussed are independent of any proprietary database management system. The models can also be extended.