Database Management Project: Analyzing Computer Lab Usage Statistics
VerifiedAdded on 2022/09/09
|18
|1016
|16
Project
AI Summary
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.
1 out of 18


















