Case Study 1: IUKL Lab Usage Problem Description:

The IUKL university computer lab's director keeps track of the lab usage, as measured by the number of students using the lab. This particular function is very important for budgeting purposes. The computer lab director assigns you the task of developing a data warehouse in which to keep track of the lab usage statistics. The main requirements for this database are to Show the total number of users by different time periods. Show usage numbers by time period, by major, and by student classification. Compare usage for different major and different semesters. The following questions are related to the following Data Warehouse database design. Please perform and answer accordingly

a) Recommend the appropriate sample data (five samples of records) for the tables as in the DW design above.

b) Create the THREE (3) reports that will meet the requirements listed in this problems introduction.

USELOG DATE TIME STUDENT_ID ACT STUDENT STUDENT_ID SEX FULL/PART TYPE CLASS_ID MAJOR_CODE CLASS CLASS_ID CLASS_DESCRIPTION MAJOR MAJOR_CODE MAJOR_NAME 81 SEMESTER EEMESTER ID SEMESTER_DESCRIPTION BEGIN_DATE END_DATE USEFACT SEMESTER ID MAJOR CODE CLASS_ID TIMED TOTAL TIME TIME ID TIME_DESCRIPTION BEGIN_TIME END_TIME