PLEASE FOLLOW THESE GUIDELINES; Exam 2 A company that specializes in IT training

Question

PLEASE FOLLOW THESE GUIDELINES;

Exam 2

A company that specializes in IT training needs a data model for the following requirements.    The company has 30 instructors. The company offers three semester terms per year. The company offers up to five courses per term. Each term has a maximum enrollment of 100 students. Each course has one assigned instructor per term. Occasionally, a course will be assigned two instructors per term. An instructor cannot teach more than two courses per term. In addition to teaching courses, an instructor may be assigned to do research projects each term. Each course has a maximum enrollment of 30 students.   Each student is required to take one course per term and may take up to three courses per term.

Required: Develop an Entity-Relationship Diagram that would represent the necessary entities and their relationships including entity names, relationship names, relationship direction arrows, and multiplicity notation for each entity in each relationship

• ER_Diagram_EXAM2.doc (23 KB)

Explanation / Answer

For some reason I cant download the above attachments. Can u mail me the same? My email id is eyedagger@gmail.com

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.