The university contains many academic departments in a college, such as the Department of Computer Engineering, Software Engineering, and English Language Teaching etc. And a variety of courses are offered by each department. And possibly an instructor can teach more than one course. For example, a physics professor can teach maths also. You need to create a database schema for this application. Notice that the database users are varied corresponding to their privileges and interest. Assuming that you have DBA, end users etc. create database schema using any RDBMS (mysql, and postgresql are preferred). Insert few record as related to your courses and department. Notice that you need to show ER-Diagram, in the latest step.