SPPU Computer Engineering (Semester 5)
Database Management Systems Applications
December 2016
Total marks: --
Total time: --
INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary


Solve any one question.Q1(a,b)Q 2(a,b)
1(a) Explain the distinctions among the terms primary key, candidate key, and super key.
5 M
1(b) Explain the concept of specialization & generlization in E-R Model using suitable example.
5 M

2(a) Explain wide column store data model of NOSQL database.
5 M
Solve any one question.Q3(a,b) Q4(a,b)
2(b) Differenitate between Relational database & NOSQL database.
5 M

3(a) Consider relational schema
Customer (name,
ccity,
phone)
Loan(Ino,
branch_name, amount)
Borrower(cname,
ino)
Depositor (cname,
accno)
Branch (bname,
bcity) Account (bname,
accno,
bal)
Write SQL queries for following requirement(Any Two):
i) Find out average account balance at each branch.
ii) Find all customers who have both account and loan at the bank.
iii) Find average account balance at Shivajinagar branch.
5 M
3(b) Write short note on performance tuning & query optimization of NOSQL database.
5 M

4(a) Write short note on crowd sourcing.
5 M
4(b) What is recoverable schedule? Why is recoverability of schedule is desirable?
5 M

Solve any one question.Q5(a,b) Q6(a,b)
5(a) What is speedup and scale up attributes in parallel database architectures? Explain the different factors affecting the speedup and scaleup attributes.
8 M
5(b) Compare 2-tier and 3-tier client server architecture with suitable example.
8 M

6(a) Explain different steps required for JAVA to SQL database connection using JDBC.
8 M
6(b) Explain distributed database system architecture.
8 M

Solve any one question.Q7(a,b) Q8(a,b,c)
7(a) Consider the requirement of library having following elements students(roll_no,
name,
class)
Teachers (ID,
Name,
department) Book (Acce._No,
Title,
author,
publisher) write XML DTD for above elements.
7 M
7(b) Write short note on:
i) HBASE
ii) HIVE
10 M

8(a) List & explain advantages of using XML Schema over XMLDTD.
7 M
8(b) Explain in brief different building blocks of HADOOP.
5 M
8(c) Write short note on Querying XML data.
5 M

Solve any one question.Q9(a,b,c) Q10(a,b,c)
9(a) Explain with neat diagram different components of data warehouse.
5 M
9(b) Write short note on Data-mining association rules.
5 M
9(c) Explain Recommendation algorithm.
7 M

10(a) What is data mining clustering? Explain how knowledge can be extracted from databases using Data Mining clustering.
5 M
10(b) Explain in brief different BIS components.
5 M
10(c) Write short note on Data-mining regression analysis.
7 M



More question papers from Database Management Systems Applications
SPONSORED ADVERTISEMENTS