多对多关系ERD [英] Many-to-many relationships ERD

问题描述

我目前正在为论文存储库设计数据库设计。我遇到这种情况：

I'm currently designing a database design for a thesis repository. I came across this situation:

•学生只能提交一个论文，并且论文可以由MANY学生提交。

• A student can submit ONLY ONE thesis, and a thesis can be submitted by MANY students.

但是，我不想让论文ID重复论文表。
我应该使用结表吗？我做了一个初步设计（下）。我在正确的轨道吗？

However, I do not want to make the Thesis ID repeat for the Thesis table. Should I use a junction table? I have made an initial design (below) with one. Am I in the right track?

推荐答案

我建议只要在student表上加上thesisID栏，

I suggest that just put thesisID column on Students Table,

这篇关于多对多关系ERD的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！