Part 1: Initial Scenario: Advera
Advera is the leading Ads publisher network that provides the inventory of Ads and connects & allows advertisers to publish or run ads on their apps or on website.
Advera is looking to develop some sort of APIs to help advertisers store or retrieve different advertisements. This initial logical data model look something link this:
This data model depicts that we have two main entities, publishers
and advertisements
and the relationship between these two entities is Many-to-Many. One of many advertisements can be published with one publisher and one publisher can store more than one advertisement. In order to create this relationship we need to create the third table ads
with two attributes that will reference the associated columns in publishers
and advertisements
tables.
The below application data model i.e. UML Class Diagram, is generated automatically using IntelliJ IDEA (Ultimate) Diagrams. This diagram reflects the structure of actual classes and methods in this application.