Consider the ER diagram below There are a few incorrect item

Consider the E-R diagram below. There are a few incorrect items in this diagram and there are a few possible changes that would make the database design better. List and explain two improvements to this design. Do not add more attributes to the design. Please tell me why I got \'0\' what\'s problem with this question?

Solution

According to me the two changes could have been:

1) the relationship between student to teacher should be N:N because 1 student can take advice from many teachers and 1 teacher can give his advice to many students.

2) the relationship between course and teacher should be 1:N beacuse 1 course can be taught by many teachers like there can be 2-3 teachers of physics but 1 teacher can only teach 1 course like a physics teacher will teach physics only.