what is a good data model?

On November 11th, 2022, an interesting question was asked to Alberto and Marco from SQLBI, about: how would you define a good data model? and this was their answer: (minute 32:18 from the video below, when clicking play it should automatically start at that point)

So, in summary:

1. 1. Needs to be star schema.
   2. No single-one table model.
   3. No bi-directional relationships.

Finally, the idea of Alberto Ferrari about coloring the tables in your data model would be awesome! Please Microsoft.

And that’s it data people, see you tomorrow.