I would like to know what is the best solution for making a parent table with multiple children?
I have to make multiple children table. One for each profile.
Is there a better idea than having 3 foreign keys in the parent table?
You can do this (assuming I'm understanding you correctly) via having foreign keys in your child tables referring to the parent table.
If you want each row in parent table to have details only in one table, you can slightly modify Simon Righarts solution: