如何解决这种情况？ [英] How to solve this situation ?

问题描述

谢谢codeProject总是在教我新东西。但是这次我想出了处理这种情况的想法。



状况：



让我们说一所大学有多门课程，有不同的部门。每个部门都有多个工作室，学生和院系。



如何为这种情况建立数据库。



ie：ABC大学提供3门课程。课程A，课程B，课程C.

和课程A有DEPTARTMENT_A，DEPTARTMENT_B，DEPTARTMENT_C。



如何建立数据库...... ？



我尝试了什么：



没有尝试过解决方案。

Thank you codeproject that always teaching me new things. But this time Im out of ideas to deal with this situation.

SITUATION:

Let, say a college have multiple course with different departments on it. And each department has multiple workshop, students and faculties.

How to make a Database for this situation.

i.e: ABC college offers 3 courses. Course A, Course B, Course C.
and Course A has DEPTARTMENT_A, DEPTARTMENT_B, DEPTARTMENT_C.

How to build database... ?

What I have tried:

Didnt tried anything but looking for solution.

推荐答案

创建一个Colleges表。

创建课程表。将一个外键添加到Colleges表的ID中。

创建一个Departments表。将外键添加到Courses表的ID中。

Create a Colleges table.
Create a Courses table. Add a foreign key to the ID of the Colleges table.
Create a Departments table. Add a foreign key to the ID of the Courses table.

这篇关于如何解决这种情况？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！