Database Management Project: Analyzing Computer Lab Usage Statistics

This project focuses on developing a database to track and analyze computer lab usage at a university. The assignment requires students to create a data warehouse using the provided University_Computer_Lab.mdb database, which includes student access data (USELOG) and student information (STUDENT). The primary goals are to display the total number of users across different time periods, analyze usage by time, major, and student classification, and compare usage patterns across different majors and semesters. The provided data, spanning various dates, shows user counts, which needs to be analyzed to meet the project requirements. The project emphasizes the practical application of database management principles through a case study, requiring students to define facts, establish relationships, and perform queries to extract meaningful insights from the data. The solution provided includes the raw data, and the aim of this project is to develop and secure a database to be used for data query and analysis.

Total number of users by different time periods
DATE 08-May-15
CountOfUsers 115
DATE 09-May-15
CountOfUsers 75
DATE 10-May-15
CountOfUsers 19
DATE 11-May-15
CountOfUsers 15
DATE 13-May-15
CountOfUsers 144
DATE 14-May-15
CountOfUsers 105
DATE 15-May-15
CountOfUsers 147
DATE 16-May-15
CountOfUsers 124
DATE 17-May-15
CountOfUsers 31
DATE 18-May-15
CountOfUsers 47
DATE 19-May-15
CountOfUsers 181
Monday, April 06, 2020 Page 1 of 18

DATE 20-May-15
CountOfUsers 198
DATE 21-May-15
CountOfUsers 226
DATE 22-May-15
CountOfUsers 273
DATE 23-May-15
CountOfUsers 160
DATE 24-May-15
CountOfUsers 32
DATE 25-May-15
CountOfUsers 43
DATE 26-May-15
CountOfUsers 214
DATE 27-May-15
CountOfUsers 289
DATE 28-May-15
CountOfUsers 253
DATE 29-May-15
CountOfUsers 264
DATE 30-May-15
CountOfUsers 165
DATE 31-May-15
CountOfUsers 39
Monday, April 06, 2020 Page 2 of 18

DATE 01-Jun-15
CountOfUsers 50
DATE 02-Jun-15
CountOfUsers 252
DATE 03-Jun-15
CountOfUsers 221
DATE 04-Jun-15
CountOfUsers 208
DATE 05-Jun-15
CountOfUsers 255
DATE 06-Jun-15
CountOfUsers 136
DATE 07-Jun-15
CountOfUsers 36
DATE 08-Jun-15
CountOfUsers 51
DATE 09-Jun-15
CountOfUsers 263
DATE 10-Jun-15
CountOfUsers 238
DATE 11-Jun-15
CountOfUsers 253
DATE 12-Jun-15
CountOfUsers 287
Monday, April 06, 2020 Page 3 of 18

DATE 13-Jun-15
CountOfUsers 179
DATE 14-Jun-15
CountOfUsers 32
DATE 15-Jun-15
CountOfUsers 77
DATE 16-Jun-15
CountOfUsers 330
DATE 17-Jun-15
CountOfUsers 340
DATE 18-Jun-15
CountOfUsers 344
DATE 19-Jun-15
CountOfUsers 290
DATE 20-Jun-15
CountOfUsers 191
DATE 21-Jun-15
CountOfUsers 63
DATE 22-Jun-15
CountOfUsers 105
DATE 23-Jun-15
CountOfUsers 327
DATE 24-Jun-15
CountOfUsers 294
Monday, April 06, 2020 Page 4 of 18

DATE 25-Jun-15
CountOfUsers 297
DATE 26-Jun-15
CountOfUsers 339
DATE 27-Jun-15
CountOfUsers 230
DATE 28-Jun-15
CountOfUsers 55
DATE 29-Jun-15
CountOfUsers 85
DATE 30-Jun-15
CountOfUsers 318
DATE 01-Jul-15
CountOfUsers 282
DATE 02-Jul-15
CountOfUsers 331
DATE 03-Jul-15
CountOfUsers 360
DATE 04-Jul-15
CountOfUsers 198
DATE 05-Jul-15
CountOfUsers 63
DATE 06-Jul-15
CountOfUsers 87
Monday, April 06, 2020 Page 5 of 18

DATE 07-Jul-15
CountOfUsers 308
DATE 08-Jul-15
CountOfUsers 298
DATE 09-Jul-15
CountOfUsers 337
DATE 10-Jul-15
CountOfUsers 93
DATE 11-Jul-15
CountOfUsers 163
DATE 15-Jul-15
CountOfUsers 1
DATE 20-Jul-15
CountOfUsers 55
DATE 21-Jul-15
CountOfUsers 314
DATE 22-Jul-15
CountOfUsers 43
DATE 27-Jul-15
CountOfUsers 72
DATE 28-Jul-15
CountOfUsers 264
DATE 29-Jul-15
CountOfUsers 209
Monday, April 06, 2020 Page 6 of 18

DATE 30-Jul-15
CountOfUsers 265
DATE 31-Jul-15
CountOfUsers 260
DATE 01-Aug-15
CountOfUsers 176
DATE 02-Aug-15
CountOfUsers 45
DATE 03-Aug-15
CountOfUsers 81
DATE 04-Aug-15
CountOfUsers 301
DATE 05-Aug-15
CountOfUsers 257
DATE 06-Aug-15
CountOfUsers 281
DATE 07-Aug-15
CountOfUsers 209
DATE 09-Aug-15
CountOfUsers 31
DATE 10-Aug-15
CountOfUsers 53
DATE 11-Aug-15
CountOfUsers 316
Monday, April 06, 2020 Page 7 of 18

DATE 12-Aug-15
CountOfUsers 311
DATE 13-Aug-15
CountOfUsers 298
DATE 14-Aug-15
CountOfUsers 299
DATE 15-Aug-15
CountOfUsers 198
DATE 16-Aug-15
CountOfUsers 58
DATE 17-Aug-15
CountOfUsers 120
DATE 18-Aug-15
CountOfUsers 399
DATE 19-Aug-15
CountOfUsers 367
DATE 20-Aug-15
CountOfUsers 302
DATE 21-Aug-15
CountOfUsers 258
DATE 22-Aug-15
CountOfUsers 193
DATE 23-Aug-15
CountOfUsers 59
Monday, April 06, 2020 Page 8 of 18

DATE 24-Aug-15
CountOfUsers 100
DATE 25-Aug-15
CountOfUsers 372
DATE 26-Aug-15
CountOfUsers 231
DATE 27-Aug-15
CountOfUsers 183
DATE 28-Aug-15
CountOfUsers 135
DATE 29-Aug-15
CountOfUsers 89
DATE 30-Aug-15
CountOfUsers 18
DATE 01-Sep-15
CountOfUsers 94
DATE 02-Sep-15
CountOfUsers 64
DATE 20-Dec-15
CountOfUsers 25
DATE 21-Dec-15
CountOfUsers 5
DATE 22-Dec-15
CountOfUsers 13
Monday, April 06, 2020 Page 9 of 18

DATE 23-Dec-15
CountOfUsers 32
DATE 24-Dec-15
CountOfUsers 27
DATE 25-Dec-15
CountOfUsers 61
DATE 26-Dec-15
CountOfUsers 52
DATE 27-Dec-15
CountOfUsers 51
DATE 28-Dec-15
CountOfUsers 22
DATE 29-Dec-15
CountOfUsers 7
DATE 31-Dec-15
CountOfUsers 77
DATE 01-Jan-16
CountOfUsers 102
DATE 02-Jan-16
CountOfUsers 139
DATE 03-Jan-16
CountOfUsers 101
DATE 04-Jan-16
CountOfUsers 27
Monday, April 06, 2020 Page 10 of 18

DATE 05-Jan-16
CountOfUsers 56
DATE 06-Jan-16
CountOfUsers 184
DATE 07-Jan-16
CountOfUsers 218
DATE 08-Jan-16
CountOfUsers 258
DATE 09-Jan-16
CountOfUsers 318
DATE 10-Jan-16
CountOfUsers 129
DATE 11-Jan-16
CountOfUsers 43
DATE 12-Jan-16
CountOfUsers 52
DATE 13-Jan-16
CountOfUsers 219
DATE 14-Jan-16
CountOfUsers 237
DATE 15-Jan-16
CountOfUsers 206
DATE 16-Jan-16
CountOfUsers 219
Monday, April 06, 2020 Page 11 of 18

DATE 17-Jan-16
CountOfUsers 110
DATE 18-Jan-16
CountOfUsers 29
DATE 19-Jan-16
CountOfUsers 63
DATE 20-Jan-16
CountOfUsers 236
DATE 21-Jan-16
CountOfUsers 224
DATE 22-Jan-16
CountOfUsers 235
DATE 23-Jan-16
CountOfUsers 253
DATE 24-Jan-16
CountOfUsers 139
DATE 25-Jan-16
CountOfUsers 44
DATE 26-Jan-16
CountOfUsers 84
DATE 27-Jan-16
CountOfUsers 272
DATE 28-Jan-16
CountOfUsers 274
Monday, April 06, 2020 Page 12 of 18