Download AKTU B-Tech 8th Sem 2016-17 NOE085 Dbms Data Mining And Warehouse Question Paper

B.TECH.

THEORY EXAMINATION (SEM–VIII) 2016-17

DBMS, DATA MINING AND WAREHOUSE

--- Content provided by⁠ FirstRanker.com ---

Time: 3 Hours

Max. Marks : 100

Note: Be precise in your answer.

SECTION - A

1. Attempt all the parts:

   --- Content provided by‌ FirstRanker.com ---

   1. What do you mean by file processing system?
   2. Explain important mapping constraints for ER model.
   3. Explain concept of super key.
   4. Define the three level architecture of DBMS.
   5. List the data types that are allowed for SQL attributes.

   --- Content provided by​ FirstRanker.com ---

   6. What do you mean by cursors in SQL?
   7. What is relational algebra?
   8. Define union and intersection using SQL.
   9. Explain integrity constraints.
   10. Explain Boyce-coded normal forms.

   --- Content provided by FirstRanker.com ---

   (10*2=20)

SECTION – B

2. Attempt any five of the following:

   1. Write down important features of SQL. Explain advantages of SQL for DBMS.

   --- Content provided by​ FirstRanker.com ---

   2. Consider the following relational schemas:

      Employee (person_name, street, city)

      Works (person name, company_name, salary)

      Company (company_name, city)

      Manages (person_name, manager_name)

      --- Content provided by‌ FirstRanker.com ---

      Give SQL commands to execute the following queries:

      1. Find the name of all employees who live in the same city and on the same street as do their managers.
      2. Find the name of all employees in this database who do not work for "First Ranker Corporation".
      3. Find the name of all employees who earn more than every of “small bank corporation”.
      4. Give all managers in this database a 10 percent salary raise.

      --- Content provided by‍ FirstRanker.com ---

   3. Discuss impact of insertion, deletion and modifications anomalies in database design.
   4. Explain multidimensional model of data warehouse. What are partitioning techniques?
   5. What do you mean by distributed DBMS? Also discuss the distributed DGBMS implementation.
   6. What do you mean by Multi valued dependency and join dependency? Discuss with suitable examples.

   --- Content provided by​ FirstRanker.com ---

   7. Discuss client/server model. Also explain 2-tier and 3-tier architecture in detail.
   8. What are the different parallel server hardware options? List the features, benefits and limitations of any one of these options.

   (10*5=50)

Attempt any two of the following:

--- Content provided by FirstRanker.com ---

(15*2=30)

3. Explain how metadata is critical for data warehouse development and administration. Also examine the concept that metadata is like a nerve centre.
4. Write an SQL query, without using ‘with' clause to find all branches where the total account deposit is less than the average total account deposit at all branches.
   1. using a nested query in the 'from' clause
   2. using a nested query in a ‘having' clause

--- Content provided by FirstRanker.com ---

5. Discuss the following :
   1. Mapping the data warehouse to a multiprocessor architecture
   2. DBMS schemes for decision support