Database Answers FIFA Scandal 2015 (Click for Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for FIFA Scandal 2015   

We would be glad to have your comments.

On the evening of Tuesday, June 2nd. 2015, it was announced that Sepp Blatter had resigned.

When I reviewed my Data Model, I was pleased to see that the design could accommodate this Event.
In fact, it offered the opportunity to add a 'rabbits-ears', reflexive or recursive relationship to the Events Entity.
In recent TV interviews, the words 'Money Laundering' have been used, which means that we might want to link to our Model on Money Laundering in the future.

Conceptual Model

Conceptual Data Model for FIFA Scandal 2015
ERD Logical Data Model (Version 1)

ERD Logical Data Model for FIFA Scandal 2015
ERD Logical Data Model (Version 2)
In version 2, I added a relationshiop between Money Transfers and Services Provided
(optional at both ends) in response to a suggestion on LinkedIn from Rodger Nixon
(Thank you, Rodger !!!) and the revelation of the payment of 5 million Euros by FIFA
to the Irish FA.

ERD Logical Data Model for FIFA Scandal 2015
ERD Logical Data Model (Version 3)
In version 3, I removed Money Transfers and considered them as a type of Events.
In view of the continued press coverage, I added a Media Coverage Entity.
An article in today's 'i' UK newspaper referred to 'leaked letters linked to Blatter'.
So I added a Document Entity.
At this point, the Model starts to look like my Canonical Data Model.
ERD Logical Data Model for FIFA Scandal 2015

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
June 10th. 2015


© DataBase Answers Ltd. 2015
About Us Contact Us