Acquiring MVN design pattern, you need to build a data model for the application described in the
Fantastic news! We've Found the answer you've been seeking!
Question:
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:
- Get list of users;
- Get list of content producers;
- Get list of content subscribers (full);
- Get list of content subscribers, subscribed on specific producer;
- Get all messages;
- Get all messages created by specific producer;
- 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:
- 2 roles
- Producer; and
- Subscriber
- The Producers role is the same as the Subscriber, but has some extra capabilities:
- The producer can produce messages, which the Subscribers get;
- User may have both roles at the same time;
- Users having the Subscriber role, which means they can subscribe to as many Producers as they want to;
- All messages stored in the database, can be easily searched based on the following criteria:
- User (Producer) ID - means who wrote it;
- Message content
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date: