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.

Summary

This is a retouched picture, which means that it has been digitally altered from its original version. The original can be viewed here: ER Diagram MMORPG.png: .

Licensing

I, the copyright holder of this work, hereby publish it under the following licenses:

	This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license.
	You are free: to share – to copy, distribute and transmit the work to remix – to adapt the work Under the following conditions: attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use. share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.
	This licensing tag was added to this file as part of the GFDL licensing update.http://creativecommons.org/licenses/by-sa/3.0/CC BY-SA 3.0Creative Commons Attribution-Share Alike 3.0truetrue

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the section entitled GNU Free Documentation License.http://www.gnu.org/copyleft/fdl.htmlGFDLGNU Free Documentation Licensetruetrue

You may select the license of your choice.

Original upload log

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.wikipedia.org en.wikipedia]; description page is/was [http://en.wikipedia.org/w/index.php?title=Image%3AER_Diagram_MMORPG.png_ here]. |

Uploaded with derivativeFX