学生/顾问应用程序的实体关系模型 [英] Entity Relationship Model for Student / Advisor application

问题描述

我正在建立一个关于学生和顾问的网络应用程序。学生将选择他的独立研究，顾问将监督它。我很难为我的程序找到正确的关系。

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?

推荐答案

这是另一个基于 ypercube 对我的其他答案的评论：

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.

这篇关于学生/顾问应用程序的实体关系模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！