Data model Assignment

Assignment Tasks:

What you should do:

1. Acquiring MVN design pattern, you need to build a data model for the application described in theAssignment Descriptionsection together with API Contracts
2. As a result, you should have the following:
   • ERD diagram (if you use RDBMS) as a picture of JPEG/PNG format;
   • Script to create the data model in the DB (SQL for RDBMS, CQL for Cassandra, etc.), which should be runnable, and creates an expected data structure;
   • Script to populate the database with few records (2-3 users, 5-7 messages);
   • A minimum of the following queries:
     1. Get list of users;
     2. Get list of content producers;

• Get list of content subscribers (full);

1. Get list of content subscribers, subscribed on specific producer;
2. Get all messages;
3. Get all messages created by specific producer;

• Get all messages for given subscriber (it may include messages from multiple producers).