CSC410 Data Warehousing and Data Mining

Data Warehousing and Data Mining TU Board 2081 question paper

12 questionsSit this paper (timed)

Tribhuvan University

Bachelor of Science in Computer Science and Information Technology

Semester 7 · TU Board 2081

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

(2 × 10 = 20)

  1. 1.

    When do we prefer trim mean for statistical description of data? Justify with an example. Describe about multi-dimensional data model and conceptual modeling of data warehouse.

    10
  2. 2.

    How do you generate strong association rules? From the following dataset find the frequent item set using FP growth algorithm using 3 as minimum support.

    Transaction ID
    Items
    T1
    {K, E, M, O, Y}
    T2
    {K, E, O, Y}
    T3
    {K, E, M}
    T4
    {K, M, Y}
    T5
    {K, E, O}

    10
  3. 3.

    Define overfitting and under fitting. Train the decision tree classifier using the ID3 algorithm based on the following training data.

    TID
    Age
    Car Type
    Class
    1
    ≤30
    Family
    High
    2
    ≤30
    Sports
    High
    3

    30
    Sports
    High
    4
    30
    Family
    Low
    5
    30
    Truck
    Low
    6
    ≤30
    Family
    High

    10

Group B

(8 × 5 = 40)

  1. 4.

    Describe any two methods of handling noisy data.

    5
  2. 5.

    Using k-means++ algorithm and Euclidean distance, find the initial 3 cluster centroids from A1 = (3, 11), A2 = (3, 6), A3 = (9, 5), A4 = (6, 9), A6 = (7, 5), A7 = (2, 3), A8 = (5, 10). Choose (3, 11) as one of the initial centroids.

    5
  3. 6.

    Explain the general strategies for cube computation.

    5
  4. 7.

    Distinguish between data characterization and data discrimination. What are the challenges of multimedia mining?

    5
  5. 8.

    Define graph mining. Discuss the conflict between theory of balance and theory of status.

    5
  6. 9.

    What is support vector? How do you evaluate the accuracy of a classifier? Describe.

    5
  7. 10.

    Differentiate between k-means and k-medoids clustering algorithm.

    5
  8. 11.

    List any two OLAP operations with example. How do you compute rule coverage and rule accuracy?

    5
  9. 12.

    Define link mining. What are the roles of epsilon and MinPts in DBSCAN.

    5

— The End —