Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 10g Database Administrator Implementation And Administration

Authors: Gavin Powell, Carol McCullough Dieter

2nd Edition

1418836656, 9781418836658

More Books

Students also viewed these Databases questions

Question

What is IUPAC system? Name organic compounds using IUPAC system.

Answered: 1 week ago

Question

What happens when carbonate and hydrogen react with carbonate?

Answered: 1 week ago

Question

1. Identify outcomes (e.g., quality, accidents).

Answered: 1 week ago