Quote:
|
Originally Posted by krasssy_lf
i am wondering if i had to extract education.account_id and the education.education_id in a separate table, so the education.account_id FK would be not needed in the education table.
|
you could do that if you wanted to, but i wouldn't
is it possible for you to insert an education row without knowing whose education it is? i.e. without knowing the account?
i doubt it, so therefore education.account_id must be NOT NULL, therefore i would leave it right there in the education table