Answered step by step
Verified Expert Solution
Link Copied!

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

  1. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Lean Knowledge Management

Authors: Roger Forsgren

1st Edition

1637421338, 978-1637421338

More Books

Students also viewed these General Management questions

Question

Explain the various employee benefit laws.

Answered: 1 week ago

Question

Describe the premium pay benefit practice.

Answered: 1 week ago