Source 1: Course Handbook The Course Handbook is a FileMaker Pro Database. It contains data regarding all courses, units and offerings of units that are offered by Silverback University. A course is made up of units, and a unit will have at least one offering each year.: COURSE (CourseCode, Version, CourseName, SchoolName) UNIT (UnitCode, CourseCode, Version, UnitName) UNIT_OFFERING (OfferingNumber, UnitCode, Year, TeachingPeriod) OFFERING_COORDINATOR (StaffID, UnitOfferingNumber)

Source 2: Student Information System The Student Information System has its data stored in a relational DBMS (Oracle) at present. STUDENT (StudentID, StudentName, DateOfBirth) ENROLMENT (EnrolNumber, StudentID, UnitOfferingNumber, Grade)

Source 3: Human Resources System The HR System is a proprietary system that is owned by the HR Department. STAFF_MEMBER(StaffNumber, StaffName, SchoolCode) SCHOOL(SchoolCode, SchoolTitle)

Source 4: Credit Database The Credit Database records where students have studied prior to attending Silverback, and the amount of credit they receive toward their Silverback degree. The data are stored in a relational DBMS (MySQL) that was developed as a student project at Silverback. STUDENT (StudentNumber, Student Name) PREVIOUS_INSTITUTION (Institution_Code, Institution_Name, Country) COURSE (Institution_Code, Course_Code, Course_Name) PREVIOUS_STUDIES (StudentNumber, Institution_Code, Course_Code, Credit_Points)

Discuss two (2) issues that may be problematic in the creation of the data warehouse that are apparent from the description above. For both, explain what you see as being the issue, why it is problematic, and what you will suggest needs to be done