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
Get step-by-step solutions from verified subject matter experts
