Draw the ER diagram for representing the information requirement of an university database:

There are several colleges in the university. Each college has a name, location, and strength. A college offers many courses over two terms- Spring and Autumn- during which one or more of these courses are offered. Courseid, name, and credit hours describe a course. No two courses in any college have the same courseid; likewise no two courses have the same name. Terms are identified by year and contain enrollment numbers. Courses are offered during every term. The college also has several instructors. Instructors teach; that is why they are called instructors. Often, not all instructors are scheduled to teach during all terms; but every term has some instructors teaching. Also, the same course is never taught by more than one instructor in a specific term. Further, instructors are capable of teaching a variety of courses offered by the college. Instructors have a unique employee ID and their name, qualification, and experience are also recorded.

这是一张修改过的图片，这意味着它已在原版本的基础上通过软件进行了编辑。其原始版本为：ER Diagram MMORPG.png。

我，本作品著作权人，特此采用以下许可协议发表本作品：

	本文件采用知识共享署名-相同方式共享 3.0 未本地化版本许可协议授权。
	您可以自由地： 共享 – 复制、发行并传播本作品 修改 – 改编作品 惟须遵守下列条件： 署名 – 您必须对作品进行署名，提供授权条款的链接，并说明是否对原始内容进行了更改。您可以用任何合理的方式来署名，但不得以任何方式表明许可人认可您或您的使用。 相同方式共享 – 如果您再混合、转换或者基于本作品进行创作，您必须以与原先许可协议相同或相兼容的许可协议分发您贡献的作品。
	本许可协议标签作为GFDL许可协议更新的组成部分被添加至本文件。http://creativecommons.org/licenses/by-sa/3.0/CC BY-SA 3.0Creative Commons Attribution-Share Alike 3.0truetrue

已授权您依据自由软件基金会发行的无固定段落及封面封底文字（Invariant Sections, Front-Cover Texts, and Back-Cover Texts）的GNU自由文件许可协议1.2版或任意后续版本的条款，复制、传播和／或修改本文件。该协议的副本请见“GNU Free Documentation License”。http://www.gnu.org/copyleft/fdl.htmlGFDLGNU Free Documentation Licensetruetrue

您可以选择您需要的许可协议。

This image is a derivative work of the following images:

• File:ER_Diagram_MMORPG.png licensed with Cc-by-sa-3.0-migrated, GFDL, GFDL-en, GFDL-self-en
  • 2007-06-22T12:32:21Z Windupduck 1600x1425 (320120 Bytes) {{Information |Description=''no original description'' |Source=Originally from [http://en-two.iwiki.icu en.wikipedia]; description page is/was [http://en-two.iwiki.icu/w/index.php?title=Image%3AER_Diagram_MMORPG.png_ here]. |

Uploaded with derivativeFX