Create a database scheme for the domain (see description). The BD scheme must correspond to at least the third normal form (3NF). DB should contain at least 7 tables with primary and foreign keys, ...
SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...