Exercise
You are tasked with designing the database for a new website where users can post articles. Users can do the following:
- Upload their own articles in predefined categories such as sports or science
- Add comments to articles
The application should be able to do the following:
- Show articles per category sorted by upload date
- Show all comments on a post
- Show a list of articles uploaded by a specific user
You can see the ERD in Figure 5.7:
Figure 5.7 – ERD exercise
Translate the ERD of Figure 5.7 into one or more JSON documents and explain the choices you made.
