Reference no: EM132865174

Using erwin, design an ER model for the following scenario:

• Each course may be taught in different classes. So for example one section of Data Management can be taught on Steven campus, another section on the WEB, a third in the DR, and a forth at an industry site (CitiGroup, etc.)
• A faculty member may be full time or part time.
• A faculty member may teach one or more classes.
• Different faculty members may teach different classes of the same course. So for example, Dr. Morabito may teach one on campus course and one Industry course of Data Management.
• Each faculty member may decide on the number of exams that may be given and the type of examinations. So the type of exam may be a midterm, quiz, class participation, lab work, or final.
• Student grades are given for each type of examination.
• Specific textbooks may be assigned to a course. Each book may have one or several authors. For example one book may be authored by another book by Kroenke and Auer.
• A student may be enrolled in one or more classes.
• Each non-web class meets in the same room for the entire semester that it is taught.