account_id -> FK to the accounts table
country_id -> FK to a nomenclature table
For one account there might be stored many educational records.
Are there any other problems that might be encountered?
Your help is kindly appreciated.
no, its not a homework. its a sample bit of a whole database for a jobportal site.
there are other tables, similarly connected to the account table (f.e certification, projects, references). i am on some stage of designing it, that i am a bit consufed about destinguishing the normal form of it although analysing the forms definitions and their examples. 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.