CSC410 Data Warehousing and Data Mining

Data Warehousing and Data Mining TU Board 2078 question paper

12 questionsSit this paper (timed)

Tribhuvan University

Bachelor of Science in Computer Science and Information Technology

Semester 7 · TU Board 2078

Course Title: Data Warehousing and Data Mining (CSC410)

Full Marks: 60Pass Marks: 24Time: 3 hours

Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.

Group A

Attempt any two questions.(2 × 10 = 20)

  1. 1.

    Write down any one advantage and disadvantage of MOLAP over ROLAP. Define signed network and how do you check whether it is balanced or not? How beam search reduces the space complexity? Illustrate with an example.

    10
  2. 2.

    How concept hierarchy is used in extracting information? Generate the frequent pattern from the following data set using FP growth, where minimum support=3.

    10
  3. 3.

    How do you compare two classifiers? Given the points A(3,7), B(4,6), C(5,5), D(6,4), E(7,3), F(6,2), G(7,2) and H(8,4), find the core points, border points and outliers using DBSCAN. Take Eps 2.5 and MinPts = 3.

    10

Group B

Attempt any eight questions.(8 × 5 = 40)

  1. 4.

    When a pattern is said to be interesting? List the issues of data mining.

    5
  2. 5.

    Define data discretization. Describe the tasks for data preprocessing.

    5
  3. 6.

    Define spatial data mining. What are the challenged of multimedia mining? Describe with an example.

    5
  4. 7.

    Consider the following data set.

    Confident
    Studied
    Sick
    Result
    Yes
    No
    No
    Fail
    Yes
    No
    No
    Pass
    No
    Yes
    Yes
    Fail
    No
    Yes
    Yes
    Pass
    Yes
    Yes
    Yes
    Pass

    Find out whether the object with attribute Confident = Yes, Sick = No will Fail or Pass using Bayesian classification.

    5
  5. 8.

    What are the choices for data cube materialization? Explain the strategies for cube computation.

    5
  6. 9.

    Show the conflict between theory of balance and status. How do you improve Apriori?

    5
  7. 10.

    Differentiate between star schema and snow flake schema. List any two methods for data normalization.

    5
  8. 11.

    How do you evaluate the accuracy of a classifier? Discuss the advantages of using K- fold cross validation.

    5
  9. 12.

    Apply K(=2)- Means algorithm over the data (185, 72), (170, 56), (168, 60), (179, 68), (182, 72), (188, 77) up to two iterations and show the clusters. Initially choose first two objects as initial centroids.

    5

— The End —