Doubt how to make Insert in this model

Question

I am developing an application that has the need to have a natural person and a legal, I would like help to know how would be the insert of this model

If I want to register a natural person I must do two insert?

Answer 1

Yes. First you enter the parent table (tbPessoa) and then the daughter table (tbPessoaFisica or tbPessoaJuridica).

INSERT INTO tbPessoa ('nmPessoa', 'dsEmail')
VALUES ('João', '[email protected]');

INSERT INTO tbPessoaFisica ('cdCpf', 'idPessoa')
VALUES ('78945698745', 'pk do insert de cima');