A University has many academic units named schools. Each school is headed by a director of school. The school has teaching and non teaching staff. A school offers many courses. A course consists of many subjects. A subject is taught to the students who have registered for that subject in a class by a teacher. Draw the ER diagram for the University specifying aggregation, generalization or specialization hierarchy, if any. Create 3NF tables of your design. Make suitable assumptions, if any.

Please do not copy this answer from another Chegg's account.