Read the following case study and answer the questions given below: Saint Paul University is a Federally Chartered Public Sector University. The principal seat of the university is at Islamabad and campuses are at Islamabad, Karachi and Lahore. The University was established by the Saint Paul Trust in 2000, and since then it has steadily grown into one of the leading higher education institutions in the country. It plays a major role in grooming future leaders who can make a positive difference to the world around them. Saint Paul University is a comprehensive university having multidisciplinary programs that includes Health Sciences, Engineering Sciences, Computer Sciences, Management Sciences, Social Sciences, Law, Earth and Environmental Sciences, Psychology and Maritime Studies. Recently, the University decided to develop a single university-wide database that could be used in the ERP system planned to be implemented in the University. Assume that Saint Paul University has hired you as an Information Management Consultant to develop the data model of their university database. The following constraints hold for the database. 1) Each permanent faculty member can teach the same course in several semesters, and each course lecture must be recorded. 2) Each permanent faculty member can teach the same course in several departments. 3) Each permanent faculty member teaches at least one course. 4) In any semester, the maximum number of courses taught by the faculty is: a. Professors--- one course b. Associate Professor--- two courses c. Assistant Professors--- three courses d. Lecturers---- four courses 5) Each visiting faculty member teaches at least one course and some visiting faculty members may teach two courses. 6) Each student can register no more than 6 courses in a semester. 7) In summer semester, a student can take no more than two courses. a. Identify the entities and attributes that could be used in this data model. b. What are the relationships between entities? c. Draw a potential data model. d. Identify the primary and foreign keys that are represented in the model. Which tables will have foreign keys?