Num of table required in the following relations ?

Question

A: Professor(prof_id,prof_name)

     Student(stud_id,stud_name)

professor-----teaches------Student

 

B: Professor(prof_id,prof_name,prof_mobile_number)

    Student(stud_id,stud_name,stud_mobile_number)

    Parent(parent_name,parent_mobile_number)

Professor---------Student---------Parent

?

Answer 1

A: Professor(prof_id,prof_name)

     Student(stud_id,stud_name)

professor-----teaches------Student
    .........................................

if it is to many to many relation then number of tables required is 3 other wise 2

Comments

If it is M:M then table required three which are

prof_id,prof_name

stud_id,stud_name

prof_id,stud_id

rt?

 

 

And if it is 1:M ,  M:1 , 1:1

then table required 1 rt?

---

And if it is 1:M ,  M:1 , 1:1

then table required 1 rt?

in above case table required is two.....i.e  for both entities ..  and one having foreign key....