Question: Construct an ERD diagram by identifying the entities, attributes and relationships in the following scenario Students at Temple University register for courses each semester. Temple

Construct an ERD diagram by identifying the entities, attributes and relationships in the following scenario

Students at Temple University register for courses each semester. Temple needs to track information on the students, including name, TUID number, major and year of study. When students register for courses, Temple tracks the course information including the course name, number of credits, school which offers the course and the course ID number.

Temple also needs to track the faculty member who teaches the course, including their employee ID number, name, email address and office location. Faculty members can have multiple office locations on the various campuses that Temple owns. The offices are noted by a building, room number and key number.

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!