Assignment Tasks:
What you should do:
1.
Acquiring MVN design pattern, you need to build a data model for the application described in the
Assignment Description
section 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:
i.
Get list of users;
ii.
Get list of content producers;
iii.
Get list of content subscribers (full);
iv.
Get list of content subscribers, subscribed on specific producer;
v.
Get all messages;
vi.
Get all messages created by specific producer;
vii.
Get all messages for given subscriber (it may include messages from multiple producers).
Assignment Submission
3.
You need to submit an archive with name pattern {Course #}_{Section #}_{Last name}_{First name}.zip containing 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.);
·
Script to populate the database with few records (2-3 users, 5-7 messages);
·
List of queries in regular text file;
Screenshots demonstrating the result of each query execution.
Please see attached document for full instructions.