I have the following tables in my database
I Want to store basic information about students and teacher in its own table, but the address and contact information in address table. If I store the
teacher_id in address table, the student might have same
id as any teacher. If I try to query any teacher address by
teacher_id. It will query the student who has the same
id as well.
So what the best way to figure out this problem? should I create any other table as well or ....
Please suggest me an easiest and best approach.
see th above example. i think best way for solving your problem.