I use MySQL Workbench and I have to represent a DER in the physical model. I come across a specialization:
TABELA_PESSOA
cpf*
nome
sexo
TABELA_CLIENTE
cpf_pessoa*
email
senha
TABELA_FUNCIONARIO
cpf_pessoa*
salario
cargo
How do I get cpf_pessoa
to be a foreign key (in both tables) for TABELA_PESSOA
and at the same time are primary keys in their respective tables?