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

Mumbai University > Information Technology > Sem 3 > Database Management System

Marks: 10M

Year: Dec 2013