CS614 GDB Spring 2012 End Date 5 July 2012

Data warehousing always leads towards the huge data storage 


and query intensive format to support analytical decisions”. 




Justify the given statement either right or wrong with strong 


arguments.

Assignment No. 03 Semester Spring 2012 Data Warehousing-CS614

	Assignment No. 03 Semester Spring 2012 Data Warehousing-CS614		Total Marks: 15 Due Date: 04/06/2012
Objective: To learn and understand basic concept of Star Schema and SQL. Instructions: Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit (get zero marks) if: o        The assignment is submitted after due date. o        The submitted assignment does not open. o        The submitted assignment is in the format other than MS Word (doc). o        The assignment is copied (from other student or copy from handouts). o        Student ID is not mentioned in the assignment File or name of file is other than student ID. For any query about the assignment, contact at cs614@vu.edu.pk GOOD LUCK
Q: Write SQL statements to construct the “Star Schema” given on the next page? Guidelines are given below: Guidelines Use appropriate data types for the table attributes. Show the Primary/Foreign key constraints. Do not send the archived file (.rar etc). “Try to upload the assignment before BONUS day”

CS614 Assignment No 4 Solution & Discussion Due Date: 09-01-2012

Question 1:   [ 08 marks ] Compare and contrast between Episode Discovery (ED) and Context Knowledge Discovery (CKDD) that are discussed in the research article. Question 2:   [ 12 marks ] In this paper four context mining techniques are discussed that are: Episode Discovery (ED), Mining user Models, Context Knowledge Discovery (CKDD) and Sequential Mobile Access Pattern-mine (SMAP-mine).In your point of view which technique is best for context mining? Provide reasons to support your answer.                                                                           Note: Try to read the research paper thoroughly, read the techniques and then give your answer briefly in points form accordingly. These techniques are discussed starting from page 23 to 28, in the article attached with your assignment. References: [1]. http://etd.aau.edu.et/dspace/bitstream/123456789/2947/1/Cover%20Pag...

Uploading Instructions: Upload your assignment as a word file. It should have name [YourRollNo.doc] Deadline Your assignment must be uploaded/submitted at or before Monday January 09, 2012.

Read more: CS614 Assignment No 4 Solution & Discussion Due Date: 09-01-2012 - Virtual University of Pakistan http://vustudents.ning.com/group/cs614datawarehousing/forum/topics/cs614-solution#ixzz1j3OJsRup