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...

1 answer below »









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.


Answered 6 days AfterJan 27, 2023

Answer To: Assignment Tasks: What you should do:1.Acquiring MVN design pattern, you need to build a...

Ashutosh Sanjay answered on Feb 03 2023
32 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here