CSC410 Data Warehousing and Data Mining

Data Warehousing and Data Mining old question papers

Pick a year on the left to see the full paper, exactly as it was set. 5 questions have come up in more than one paper.

12 questionsSit this paper (timed)

Tribhuvan University

Bachelor of Science in Computer Science and Information Technology

Semester 7 · TU Board 2082

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 question(2 × 10 = 20)

  1. 1.

    Define strong association rule. What are the limitations of Apriori algorithm? Create a FP tree from the following data set.

    TID
    List of Items
    T1
    {A, B, C}
    T2
    {B, C, D}
    T3
    {C, D}
    T4
    {B, D}
    T5
    {A, C}
    T6
    {A, C, D}

    10
  2. 2.

    What is the role of Laplace smoothing? Create a decision tree from the following data set using ID3 as attribute selection approach.

    Object
    A1
    A2
    Class
    1
    T
    T
    C1
    2
    T
    T
    C1
    3
    T
    F
    C2
    4
    F
    F
    C1
    5
    F
    T
    C2
    6
    F
    T
    C2

    10
  3. 3.

    Consider the data set (6,3), (7,2), (4,8), (2,2), (0,2), (9,0). Taking k=3, show the result after first iteration using k-means algorithm. For choosing initial centroid, use k-means++ by taking (6,3) as initial cluster center.

    10

Group B

Attempt any EIGHT question(8 × 5 = 40)

  1. 4.

    Explain about data mining primitives.

    5
  2. 5.

    Define support vector. Write the algorithm for back propagation for classification.

    5
  3. 6.

    What is data mart? Why do we need multidimensional data model?

    5
  4. 7.

    Describe the different types of data object and attribute types.

    5
  5. 8.

    What is data cube? List the different variations of cube materializations.

    5
  6. 9.

    What is the concept behind beam search? Discuss about theory of balance and status.

    5
  7. 10.

    Explain about web content, web usage and web structure mining.

    5
  8. 11.

    Given the following distance matrix, find the core points and outliers using DBSCAN. Take Eps = 2.5 and MinPts = 3.

    Data Points
    A
    B
    C
    D
    E
    F
    G
    H
    A
    0
    1.41
    2.83
    4.24
    5.66
    5.83
    6.40
    5.83
    B
    0
    1.41
    2.82
    4.24
    4.47
    5.00
    4.47
    C
    0
    1.41
    2.82
    3.16
    3.60
    3.16
    D
    0
    1.41
    2.00
    2.24
    2.00
    E
    0
    1.41
    1.00
    1.41
    F
    0
    1.00
    2.82
    G
    0
    2.24
    H
    0

    5
  9. 12.

    List the components of data warehouse. Discuss about the trust propagation on social network.

    5

— The End —