问题描述
我正在建立一个关于学生和顾问的Web应用程序。学生将选择他的独立研究，顾问将负责监督。我正在努力为我的程序找到正确的关系。
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.
我的应用程序中的actor基本上是。
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监督学生X.我该怎么做？
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:
在这个模型中，如果有一个顾问记录，协调员的身份证号码是ID，则协调员是一名顾问。
In this model, if there's an Adviser record with the Coordinator's id as it's id, that Coordinator is an Adviser.
这篇关于学生/顾问申请的实体关系模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！