The university computer lab’s director keeps track of lab usage, as measured by the number of students using the lab. This function is important for budgeting purposes. The computer lab director assigns you the task of developing a data warehouse 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 majors and different semesters

Use the Ch13_P1.mdb database, which includes the following tables:

• USELOG contains the student lab access data.

• STUDENT is a dimension table that contains student data.

Given the three preceding requirements, and using the Ch13_P1.mdb data, complete the following problems:

a. Define the main facts to be analyzed. (These facts become the source for the design of the fact table.)

b. Define and describe the appropriate dimensions. (These dimensions become the source for the design of the dimension tables.)

c. Draw the lab usage star schema, using the fact and dimension structures you defined in Problems 1a and 1b.

d. Define the attributes for each of the dimensions in Problem 1b.

e. Recommend the appropriate attribute hierarchies.

f. Implement your data warehouse design, using the star schema you created in Problem 1c and the attributes you defined in Problem 1d.

g. Create the reports that will meet the requirements listed in this problem’s introduction.

Matlab question: use switch and anythe lottery game matches three different integer numbers between 1 and 10. winning depends on how many matching numbers are provided by a player. the player provides three different integers between 1 and 10.if there is a match of all 3 numbers, the winning $ 1000.if there is a match with 2 numbers, the winning $ 10.if there is a match of all with 1 numbers, the winning $ 1.with no match, the winning is $0.write a function lottery3 that checks three numbers provided by a player and determine the winning amount. if the user mistakenly enters same number twice/thrice and if that number matches one of the winning numbers, the code should count that number only once and display correct result. the player doesn’t have to guess the order of numbers.the input to the function lottery3 can have up to two input arguments. the first input argument is a row array numbers with 3 numbers. if the second argument input testcode is present, and is a row vector of 3 values, the function lottery3 uses the code in testcode as the three winning numbers (the test must be three different integer numbers between 1 and 10), else three different numbers will be automatically generated by testcode.the ouput should return the variable winnings and the three winning numbers in the row array winnumbers.hint: make use of the internal function any.restriction: the function must use switch-case statements to determine the winning.example #1: winning = lottery3( [1,2,1],[1,2,3])produceswinning =10example #2: [winning,winnumbers] = lottery3( [1,2,3])produceswinning =3winnumbers =8 5 3

Spoons are designed to be used for: spring hammering. applying body filler. identifying high and low spots. sanding highly formed areas.

List 3 items that were on kens resume that should have been excluded