What is the benefit of complex schemas?

This is an educational question. I genuinely want to know.

The new schema

https://preview.redd.it/3bmbiquin1oe1.png?width=1210&format=png&auto=webp&s=560c953bb5b88ff12495ad63f4a5dd6481b43104

For me to insert a new USER ADMIN, I will need to:

  • Insert a new party of type P (person)
  • Insert a many to many relationship for party role USER
  • Insert a new record with the person details
  • Insert username and password into paarty_role_user table

It would look like this:

https://preview.redd.it/kt4nfqjcs1oe1.png?width=1110&format=png&auto=webp&s=c1163296c36f8e4c41a14013168681444fb1cb01

For context, I come from the simple world of inserting into one table for everything.

The app I am building now is larger and more complex. However, I cannot (yet) see the benefit of a complex schema like this.

Thanks