Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
- 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.
give me the answer with the image of er model
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started