Draw an ER diagram for university database consisting of four entities

i. Student

ii. Department

iii. Class

iv. Faculty and convert into tables

  • A student has a unique id and can enroll for multiple classes and has at most one major
  • Faculty must belong to department and faculty can take multiple classes
  • Every student will get a grade for the class for he/she was enrolled
1 Answer

enter image description here

Please log in to add an answer.