--- title: "College warehouse project leader responsibilities" subject: "Data Mining" chapter: 1 key: "semester_7/data_mining:cmis-college-warehouse-project" source: https://www.bctengineer.com/q/semester_7/data_mining/cmis-college-warehouse-project site: BCT Engineering --- # College warehouse project leader responsibilities Data Mining · Chapter 1: Introduction - Asked in: year not given, 9 marks - Answer checked by Claude Opus 5.5 (high effort) on 2026-10-14 - Page: https://www.bctengineer.com/q/semester_7/data_mining/cmis-college-warehouse-project - Whole chapter: https://www.bctengineer.com/md/semester_7/data_mining/chapter-1 ## Question Assume that your college has a perfect software package named College Management Information System (CMIS) which includes Teacher Database, Student Database, Staffs Database and Account Database and also manages tutorials, class notes through web. There is a facility of online assessment examination system that might be controlled by each subject teacher. Except this, now your College management board has passed to develop a project named college warehouse system and announced the tender notice through college web. Suppose that you are the project leader of this warehouse development system. As a project leader, (a) What are your responsibilities? (b) Divide the project into sub-system and describe the responsibilities assigned to your other partners with the help of your warehouse system architecture. ## Short answer The project leader defines scope, plans, selects architecture, ensures data quality, coordinates team, and manages deployment. Sub-systems include requirement/design, load manager (ETL), warehouse manager (transform, aggregate), query manager, data marts (Academic, HR, Finance), front-end tools, and testing/training, each assigned to partners. ## Answer #### Assumptions CMIS holds teacher, student, staff, account and online-exam data in separate databases. The warehouse will give management analysis such as student performance trend, fee collection, staff workload and finance. #### (a) Responsibilities of the project leader - Understand management needs and define scope, goals and deliverables. - Prepare the project plan, schedule, budget and risk plan; submit the tender proposal. - Form the team and assign roles; coordinate between them. - Select the architecture (bottom-up with data marts), hardware, DBMS and tools. - Ensure data quality, security and privacy of student and staff data. - Monitor progress and quality, manage changes, report to the board. - Arrange testing, user training, deployment and maintenance. #### (b) Sub-systems and responsibilities ```text Student DB Teacher DB Staff DB Account DB Exam DB \ | | | / v v v v v [ LOAD MANAGER (ETL) ] v [ WAREHOUSE MANAGER ] v Detailed | Summary | Metadata | Data marts Academic HR Finance v [ QUERY MANAGER ] v Reports | OLAP | Mining tools ``` | Sub-system | Partner responsibility | |---|---| | Requirement and design | Study CMIS, define fact/dimension models (Result fact: student, subject, teacher, time) | | Load manager | Extract from the five databases, clean, load to staging | | Warehouse manager | Transform, merge, aggregate, index, back-up, archive, metadata | | Query manager | Route and schedule queries, user access control | | Data marts | Academic, HR, Finance marts | | Front end | Dashboards, OLAP, mining (pass-fail prediction, dropout analysis) | | Testing and training | Verify data accuracy, train users | ## Check yourself The answer's key points as multiple-choice questions, with the correct option and why. 1. Which is a project leader's responsibility? A. Only testing B. Defining scope, plan, budget, risk, team roles and reporting to the board C. Writing every ETL script D. Only training Answer: B. The leader plans, coordinates and monitors. (Key point: Project leader duties) 2. What does the load manager extract from? A. Only the Account DB B. Only the web C. The five CMIS databases: Student, Teacher, Staff, Account, Exam D. Data marts Answer: C. It extracts from all five source databases and loads to staging. (Key point: Load manager sources) 3. Which marts are proposed? A. Academic, HR, Finance B. Health, Tax, Land C. Retail, Banking, Telecom D. Sales, Stock, Customer Answer: A. The college has Academic, HR and Finance marts. (Key point: Data marts) 4. Which mining task is suggested? A. Pass-fail prediction and dropout analysis B. Gene clustering C. Tumour detection D. Fraud on cards Answer: A. Front-end tools support mining like pass-fail prediction. (Key point: Front-end mining) ## Related in Data Mining - [Data warehouse vs database](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-vs-database) — Data Mining, chapter 1 - [DMQL; transactional vs warehouse database](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Admql-transactional-vs-dw) — Data Mining, chapter 2 - [Kathmandu Mall warehouse architecture](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Akathmandu-mall-warehouse) — Data Mining, chapter 1 - [National data warehouse process architecture](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Anepal-national-data-warehouse) — Data Mining, chapter 1 - [DW characteristics vs operational database](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-characteristics-vs-operational) — Data Mining, chapter 1 - [RDBMS vs DW database; DW terms](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Ardbms-vs-dw-terms) — Data Mining, chapter 1 ## Related in other subjects - [Project management information system](https://www.bctengineer.com/question.md?key=semester_7%2Fict_project_management%3Apmis) — ICT Project Management, chapter 7 - [Event management system summary and class diagram](https://www.bctengineer.com/question.md?key=semester_6%2Fobject_oriented_analysis_and_design%3Aoems-executive-summary-class-diagram) — Object Oriented Analysis and Design, chapter 2 - [System view of project management](https://www.bctengineer.com/question.md?key=semester_7%2Fict_project_management%3Asystem-view-three-parts) — ICT Project Management, chapter 5 - [Abstract Student class program](https://www.bctengineer.com/question.md?key=semester_3%2Fobject_oriented_programming%3Astudent-abstract-program) — Object Oriented Programming, chapter 7