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.

Solution

1) the arrow will be from teacher to student in the action box because it would be clear that one teacher advises many students but vise versa is not correct.

2) The action box between course and student is incorrect there will be n from student side and 1 from course side because student can opt only one course at a time.

 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

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site