Problem: The aim of this assignment is to develop a database system to hold records for students and their training programs. The system will be used for analyzing the students' performance during the training program as well as to select students of the year based on the data entered into the system. But university is organized into several departments which are described by a name, department code, office number, office phone, and a particular instructor who manages the department. We keep track of the start date when that instructor began managing the department.