Practice designing simple databases?

Question

Database design

I study SQL (I write, parse simple queries), but I would like to practice and design simple databases, both for understanding and for social security. (comrades say at every social work for interns they ask to build this or that scheme). Can you recommend some resources or just write examples? I will be grateful.

Answer 1

In fact, there are a million articles and books on the database where there are examples and descriptions, but now I remember that from scratch it is so difficult to immediately understand what will happen. If there is an opportunity, it is easier to ask or hire someone who will explain in a couple of hours, show and tell you what's what. Of course, you can figure it out yourself, but it won’t take a couple of hours or even a couple of days. But if you want to do it yourself, then take any book on databases there, it explains in great detail what's what, it's just information from the series "I read it, understood everything, but I can't do it myself", so it's better to ask for help

Answer 2

Almost every project in the database schema needs to implement an access control model.
As an example, create a schema that implements a role-based access control (RBAC) model. In the future, you can use this template for your future projects.