A University consist of many Teachers. Those Teachers teaches in several departments. Each Department offers numerous programs
Question:
A University consist of many Teachers. Those Teachers teaches in several departments. Each Department offers numerous programs and each program contains many courses. Teachers can teach many different courses and even the same course numerous times. Courses can also be taught by many Teachers. A student is registered in only one program but a program can contain many students. Students can registered in many courses at the same time and the courses have many students enrolled. Dean of departments decides which teacher to teach which courses. Students have Mid and final exams in a semester for assessment. Results are being uploaded on university website.
Identify the Entities in given scenario and Draw ER diagram.
Statistics for Business and Economics
ISBN: 978-0132930192
8th edition
Authors: Paul Newbold, William Carlson, Betty Thorne