Assignment on Datawarehousing


Question Description:

30

everything attached here. Document Preview: INN343 ASSIGNMENT 1 Data Warehousing and Mining INN343 Assignment 1 Data Warehousing Design Portfolio Required to be submitted: 1. Weekly quiz questions on lecture reading materials in weeks 2 to 5, submitted through Blackboard tests (Question 0) 2. Report with your responses to Questions 1-5 (submitted as 1 pdf file through Safe Assign) Group working: You may work on this assignment in pairs for questions 1-5. Note only a single submission is required from each pair (submissions for question 0 are made individually online) Due date: Monday 14th April – 9am Weighting: 30% of the assessment for INN343. Question 0) (5 marks) You are required to provide a total of 4 quiz questions on the weekly required readings. Every week from week 2 to week 5, by 10am you will provide one quiz question. The questions must be in your own words and not sentences or itemised lists copied from the book. Short answer questions are worth 1 point and multiple choice questions are worth 2 marks. Short answer questions must be about understanding rather than pure knowledge (eg. avoid pure definitional questions). Multiple choice questions must propose 4 alternatives, at least 2 of which must be plausible enough. There can also be more than one correct answer in the alternatives. The maximum you get for the assignment is 5 marks over the 4 questions (even if you get between 6 and 8 marks by providing up to 4 multiple choice questions). Question 1) (5 marks) Read the paper provided with the assignment: “Development of traditional Chinese medicine clinical data warehouse for medical knowledge discovery and decision support” by Xuezhong Zhou, Shibo Chen, Baoyan Liu, Runsun Zhang, Yinghui Wang, Ping Li, Yufeng Guo, Hua Zhang, Zhuye Gao and Xiufeng Yan, published in Artificial Intelligence in Medicine, Volume 48, Issues 2–3, February–March 2010, Pages 139–152. (1) Based on the entities listed on the conceptual view on figure 3, provide a star schema for the fact “treatment” (2 marks) (2) Explain… Attachments: CarRentalData….xlsx INN343-asm1-2….pdf INN343-asm1-T….pdf

Answer

30