Question: Question: Build an Entity-Relationship (ER) model Answers need to include (Entities, Attributes, Associations, Identifiers (PKs), FKs, Domains - Selected (optional)) Each course may be taught

Question: Build an Entity-Relationship (ER) model

Answers need to include (Entities, Attributes, Associations, Identifiers (PKs), FKs, Domains - Selected (optional))

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 e x a m s that may be given and the type of examinations. So the type of e x a mmay 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!