Question
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
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.
Question
Draw a potential data model.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started