问题描述
我正在建立一个关于学生和顾问的网络应用程序。学生将选择他的独立研究，顾问将监督它。我很难为我的程序找到正确的关系。
I'm building a web application concerns a student and an adviser. The student will select his independent study and an adviser will supervise it. I am struggling to find the correct relationship for my program.
基本上我的应用程序中的actors是。
Basically the actors in my application are.
a Student can select 1 independent study.
a Student can only have 1 Adviser.
an Adviser can supervise multiple Students.
a coordinator can be an adviser also
我试图为我的申请做ERD。 p>
My attempt to make ERD for my application.
Student - > Adviser (1 to many)
Coordinator - > Adviser (1 to 1)
但问题是我需要一个表，指示顾问A监督
But the problem is that I need a table that indicates that advisor A supervises student X. How should I do this?
推荐答案
这是另一个基于对我的的评论：
Here's another ERD based on ypercube's comments on my other answer:
在此模型中，如果有一个Adviser记录，协调员的ID为其ID，则该协调员为顾问。
In this model, if there's an Adviser record with the Coordinator's id as it's id, that Coordinator is an Adviser.
这篇关于学生/顾问应用程序的实体关系模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！