DF University is an international university. It has a dedicated office to handle international student matters, particularly enrolment, payments, and marketing campaigns. This office has an operational system that maintains all the details of international students enrolled at DF. Payment details are also handled by this office. Basically, the operational system has the following features:

Every student details are kept in the database. This includes the courses that the students enrol.

As DF University is a multi-campus university, some courses are offered in a different campus. DF International Office handles international students of all campuses.

Some international students coming to DF are handled by an educational agent. This is particularly common for the first course that a student enrols in. Subsequent courses are not normally handled by an agent, because the students themselves deal directly with DF University.

International students pay tuition fees several times (normally once every semester) for each course they are doing.

An E/R diagram to show the current operational system is shown as follows:

[url=https://up.top4top.net/][img]https://c.top4top.net/p_1065csjia1.png[/img][/url]

The operational database that maintains the above system has following tables:

STUDENT (StuID, Lname, Fname, Address, Phone, DOB, Country, VisaExpDate, Sponsor)

CAMPUS (CampusID, Description, Address)

COURSE (CourseCode, CourseName, Duration, CourseLevel, CampusID)

AGENT (AgentNum, AgentName, Address, PhoneNum, ContactPerson)

ENROLMENT (EnrolID, StartSemesterYear, Status, StuID, AgentNum, CourseCode)

PAYMENT (PaymentNum, Date, Amount, StuID, EnrolID)

DF International Office now requires a data warehouse for analysis purposes. The analysis is needed for identifying at least the following questions:

How many students come from certain countries?

What is the total income for certain postgraduate courses?

How many students are handled by certain agents?

How the number of enrolment of courses fluctuates across different semesters (years)?

The first question could be used by the management to identify countries that may be targeted for future international marketing campaigns. The second question could be used by the financial office for further planning. The third question could be used in conjunction with future international marketing campaigns.

Hence, your tasks are as follow:

Draw a star schema containing dimensions and fact, together with their attributes.

Define the SQL statements for the implementation of the dimensions only.