Acquiring MVN design pattern, you need to build a data model for the application described in the Assignment Description section together with API Contracts. What would an Entity relationship model look like for this database with a microservice archtechure. 1 database for the user management (user and roles) and another for the message and subscriptions. 

2. As a result, you should have the following:

• Script to create the data model in the DB (SQL for RDBMS), which should be runnable, and creates an expected data structure;
• Script to populate the database with few records (2-3 users, 5-7 messages) and all other related information;
• A minimum of the following queries:
  1. Get list of users;
  2. Get list of content producers;
  3. Get list of content subscribers (full);
  4. Get list of content subscribers, subscribed on specific producer;
  5. Get all messages;
  6. Get all messages created by specific producer;
  7. Get all messages for given subscriber (it may include messages from multiple producers).

 

Scenario:

In this assignment you will start by developing a backend for a Twitter-like application. 

The functionality of the application should have the following:

1. 2 roles
   1. Producer; and
   2. Subscriber
2. The Producers role is the same as the Subscriber, but has some extra capabilities:
   1. The producer can produce messages, which the Subscribers get;
3. User may have both roles at the same time;
4. Users having the Subscriber role, which means they can subscribe to as many Producers as they want to;
5. All messages stored in the database, can be easily searched based on the following criteria:
   1. User (Producer) ID - means who wrote it;
   2. Message content