STUPIDSID
1(a)
Discuss how each of the following operators can be parallelized using data partitioning.
i) Sorting
ii) Join
i) Sorting
ii) Join
10 M
solve any one question from Q.1(b)(i) & Q1(b)(ii).
1(b)(i)
Consider the following relations Employee
(id,
name,
dept,
gross_salary,
net_salary,
DA,
HRA,
PF) Department (dept_name,
room,
HOD,
location) Projects (p_id,
name,
dept_name)
Give two examples that world be meaningful for horizontal fragmentation.
ii) Give an example for mixed fragmentation.
iii) Give an example for vertical fragmentation.
(id,
name,
dept,
gross_salary,
net_salary,
DA,
HRA,
PF) Department (dept_name,
room,
HOD,
location) Projects (p_id,
name,
dept_name)
Give two examples that world be meaningful for horizontal fragmentation.
ii) Give an example for mixed fragmentation.
iii) Give an example for vertical fragmentation.
10 M
1(b)(ii)
Consider following schema for Jet Airline system
Customer (cust_id,
title,
name,
gender,
age,
address,
mobile_no,
email) Flight( flight_no,
dept_date,
dept_time,
arrival_date,
arrival_time)
Seat( flight_no,
cust_id,
dept_date,
seat_no,
cust_id)
Explain the different types of transparencies in distributed database with respect to above schema.
Customer (cust_id,
title,
name,
gender,
age,
address,
mobile_no,
email) Flight( flight_no,
dept_date,
dept_time,
arrival_date,
arrival_time)
Seat( flight_no,
cust_id,
dept_date,
seat_no,
cust_id)
Explain the different types of transparencies in distributed database with respect to above schema.
10 M
solve any one question from Q.2(a)(i) & Q2(a)(ii).
2(a)(i)
Design Object Relational Schema for Multiplex system.
10 M
2(a)(ii)
Design ODL Schema for payroll system
10 M
2(b)
What are the spatial operations possible on spatial database? Explain with examples.
10 M
solve any one question from Q.3(a)(i) & Q3(a)(ii).
3(a)(i)
What is difference between data warehouse and data mart? Explain data warehouse design strategies with advantages and disadvantages for each.
10 M
3(a)(ii)
Draw and explain data warehouse architecture
10 M
3(b)
Show updates to the following dimension table. Consider Type 1,
2,
3 Changes wherever applicable. Customer (customerId,
Name,
Code,
Marital status,
Address,
State,
Zip).
i) Wrongly entered Name: Kriti Gupta. Correct this Name to Kriti Sharma.
ii) Change the Martial status of the above customer from single to Married from the date Oct 1 2016.
ii) Temporary change in address of the above customer from New England to Chicago from 1 Dec 2015.
2,
3 Changes wherever applicable. Customer (customerId,
Name,
Code,
Marital status,
Address,
State,
Zip).
i) Wrongly entered Name: Kriti Gupta. Correct this Name to Kriti Sharma.
ii) Change the Martial status of the above customer from single to Married from the date Oct 1 2016.
ii) Temporary change in address of the above customer from New England to Chicago from 1 Dec 2015.
10 M
solve any one question from Q.4(a)(i) & Q4(a)(ii).
4(a)(i)
What are the types of data transformation? Explain any five in detail.
10 M
4(a)(ii)
What are the different characteristics of dimension and fact table? Demonstrate with suitable examples.
10 M
4(b)
Design Snowflake Schema and Fact Constellation Schema for Banking system
10 M
5
Explain following
i) Differentiate between relational and object relational database
ii) Need for object based database
i) Differentiate between relational and object relational database
ii) Need for object based database
10 M
6
While working as a database analyst for Banking system, you are asked to he part of its data warehouse teams. Project group is ready to make a final decision between ROLAP and MOLAP. According to you which type of OLAP model should be used and why?
10 M
More question papers from Advanced Database Management Systems