Computers and Technology, 04.03.2020 02:31 iamsecond235p318rq

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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 11:50

While preforming before operation pmcs, you notice the front right tire appears slightly under-inflated. what is the proper action?

Answers: 3

Answer

Computers and Technology, 23.06.2019 18:30

This program should be a short piece of code that prints all of the positive integers from 1 to 100 as described more fully below. the program may contain multiple methods, and if using an oo language, should be contained within a single class or object. the program should be designed so that it begins execution when invoked through whichever mechanism is most common for the implementation language. â–ş print out all positive integers from 1 to 100, inclusive and in order. â–ş print messages to standard output, matching the sample output below. â–ş in the output, state whether the each integer is 'odd' or 'even' in the output. â–ş if the number is divisible by three, instead of stating that the number is odd or even, state that the number is 'divisible by three'. â–ş if the number is divisible by both two and three, instead of saying that the number is odd, even or divisible by three; state that the number is 'divisible by two and three'. â–ş design the logic of the loop to be as efficient as possible, using the minimal number of operations to perform the required logic. sample output the number '1' is odd. the number '2' is even. the number '3' is divisible by three. the number '6' is divisible by two and three.

Answers: 1

Answer

Computers and Technology, 24.06.2019 15:30

During the software planning process, rick, a project manager, finds that his team has made an incorrect estimation of funds. what kind of risk has rick identified? rick has identified a risk.

Answers: 1

Answer

Computers and Technology, 24.06.2019 21:50

The use of phrases, fragments, and punctuation can influence the mood of a passage; keeping this in mind, how would you describe the mood of the followingpassage? "fog on the essex marshes, fog on the kentish heights, fog creeping into the cabooses of collier-brigs; fog lying out on the yards, and hovering in the riggingof great ships; fog drooping on the gunwales of barges and small boats. fog in the eyes and throats of ancient greenwich pensioners, wheezing by thefiresides of their wards; fog in the stem and bowl of the afternoon pipe of the wrathful skipper; fog cruelly pinching the toes and fingers of his shivering little'prentice boy on deck." (5 points)

Answers: 2

Answer

You know the right answer?

The university computer lab’s director keeps track of lab usage, as measured by the number of studen...

Questions