What is the best approach database structure for teacher, students and address table? : <p>I have the following tables in my database</p>

<ul>
<li>students</li>
<li>teachers </li>
<li>address</li>
</ul>

<p>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 <code>student_id</code> or <code>teacher_id</code> in address table, the student might have same <code>id</code> as any teacher. If I try to query any teacher address by <code>teacher_id</code>. It will query the student who has the same <code>id</code> as well. </p>

<p>So what the best way to figure out this problem? should I create any other table as well or .... </p>

<p>Please suggest me an easiest and best approach.</p>

<p>thanks.</p>
