Final Database Management Project: University Computer Lab Analysis

This project focuses on developing a database for the university computer lab, designed to track and analyze lab usage data for budgeting and resource allocation. The assignment involves creating a data warehouse using provided data from the USELOG and STUDENT tables, to fulfill specific requirements: showing total users by time period, usage numbers by time period, major, and student classification, and comparing usage across majors and semesters. The solution demonstrates the ability to define facts, design queries, and generate reports based on the provided data, offering insights into student lab usage patterns. The project highlights the practical application of database management principles through a real-world case study, providing valuable experience in data warehousing and analysis.

Usage numbers by time period
DATE CountOfuUsage
08-May-15 115
09-May-15 75
10-May-15 19
11-May-15 15
13-May-15 144
14-May-15 105
15-May-15 147
16-May-15 124
17-May-15 31
18-May-15 47
19-May-15 181
20-May-15 198
21-May-15 226
22-May-15 273
23-May-15 160
24-May-15 32
25-May-15 43
26-May-15 214
27-May-15 289
28-May-15 253
29-May-15 264
30-May-15 165
31-May-15 39
01-Jun-15 50
02-Jun-15 252
03-Jun-15 221
04-Jun-15 208
05-Jun-15 255
Monday, April 06, 2020 Page 1 of 7

DATE CountOfuUsage
06-Jun-15 136
07-Jun-15 36
08-Jun-15 51
09-Jun-15 263
10-Jun-15 238
11-Jun-15 253
12-Jun-15 287
13-Jun-15 179
14-Jun-15 32
15-Jun-15 77
16-Jun-15 330
17-Jun-15 340
18-Jun-15 344
19-Jun-15 290
20-Jun-15 191
21-Jun-15 63
22-Jun-15 105
23-Jun-15 327
24-Jun-15 294
25-Jun-15 297
26-Jun-15 339
27-Jun-15 230
28-Jun-15 55
29-Jun-15 85
30-Jun-15 318
01-Jul-15 282
02-Jul-15 331
03-Jul-15 360
04-Jul-15 198
05-Jul-15 63
06-Jul-15 87
Monday, April 06, 2020 Page 2 of 7

DATE CountOfuUsage
07-Jul-15 308
08-Jul-15 298
09-Jul-15 337
10-Jul-15 93
11-Jul-15 163
15-Jul-15 1
20-Jul-15 55
21-Jul-15 314
22-Jul-15 43
27-Jul-15 72
28-Jul-15 264
29-Jul-15 209
30-Jul-15 265
31-Jul-15 260
01-Aug-15 176
02-Aug-15 45
03-Aug-15 81
04-Aug-15 301
05-Aug-15 257
06-Aug-15 281
07-Aug-15 209
09-Aug-15 31
10-Aug-15 53
11-Aug-15 316
12-Aug-15 311
13-Aug-15 298
14-Aug-15 299
15-Aug-15 198
16-Aug-15 58
17-Aug-15 120
18-Aug-15 399
Monday, April 06, 2020 Page 3 of 7

DATE CountOfuUsage
19-Aug-15 367
20-Aug-15 302
21-Aug-15 258
22-Aug-15 193
23-Aug-15 59
24-Aug-15 100
25-Aug-15 372
26-Aug-15 231
27-Aug-15 183
28-Aug-15 135
29-Aug-15 89
30-Aug-15 18
01-Sep-15 94
02-Sep-15 64
20-Dec-15 25
21-Dec-15 5
22-Dec-15 13
23-Dec-15 32
24-Dec-15 27
25-Dec-15 61
26-Dec-15 52
27-Dec-15 51
28-Dec-15 22
29-Dec-15 7
31-Dec-15 77
01-Jan-16 102
02-Jan-16 139
03-Jan-16 101
04-Jan-16 27
05-Jan-16 56
06-Jan-16 184
Monday, April 06, 2020 Page 4 of 7

DATE CountOfuUsage
07-Jan-16 218
08-Jan-16 258
09-Jan-16 318
10-Jan-16 129
11-Jan-16 43
12-Jan-16 52
13-Jan-16 219
14-Jan-16 237
15-Jan-16 206
16-Jan-16 219
17-Jan-16 110
18-Jan-16 29
19-Jan-16 63
20-Jan-16 236
21-Jan-16 224
22-Jan-16 235
23-Jan-16 253
24-Jan-16 139
25-Jan-16 44
26-Jan-16 84
27-Jan-16 272
28-Jan-16 274
29-Jan-16 250
30-Jan-16 248
31-Jan-16 111
01-Feb-16 12
02-Feb-16 104
03-Feb-16 316
04-Feb-16 13
10-Feb-16 47
11-Feb-16 263
Monday, April 06, 2020 Page 5 of 7

DATE CountOfuUsage
12-Feb-16 291
13-Feb-16 275
14-Feb-16 46
15-Feb-16 35
16-Feb-16 71
17-Feb-16 238
18-Feb-16 259
19-Feb-16 317
20-Feb-16 292
21-Feb-16 143
22-Feb-16 39
23-Feb-16 80
24-Feb-16 230
25-Feb-16 217
26-Feb-16 219
27-Feb-16 213
28-Feb-16 188
01-Mar-16 82
02-Mar-16 299
03-Mar-16 255
04-Mar-16 228
05-Mar-16 270
06-Mar-16 159
07-Mar-16 41
08-Mar-16 84
09-Mar-16 246
10-Mar-16 312
11-Mar-16 224
12-Mar-16 263
13-Mar-16 167
14-Mar-16 58
Monday, April 06, 2020 Page 6 of 7

DATE CountOfuUsage
15-Mar-16 129
16-Mar-16 337
17-Mar-16 333
18-Mar-16 164
22-Mar-16 91
23-Mar-16 312
24-Mar-16 332
25-Mar-16 315
26-Mar-16 321
27-Mar-16 176
28-Mar-16 58
29-Mar-16 116
30-Mar-16 356
31-Mar-16 362
01-Apr-16 334
02-Apr-16 313
03-Apr-16 139
04-Apr-16 28
05-Apr-16 62
06-Apr-16 125
07-Apr-16 125
08-Apr-16 140
09-Apr-16 119
10-Apr-16 48
Monday, April 06, 2020 Page 7 of 7