STUPIDSID
This Qs paper appeared for DBT of
Information Technology (Semester 6)
1 (a)
Explain Replication in Database.
5 M
1 (b)
Explain BCNF with Example.
5 M
1 (c)
Compare Data mart and Data Warehouse.
5 M
1 (d)
Explain Nested Relations.
5 M
2 (a)
Suppose that we decompose the schema
R = (A, B, C, D, E) into (A, B, C) and
(A, D, E)Show that this decomposition is a lossless join decomposition if the following set F of functional dependencies hold:
A ? BC
CD ? E
B ? D
E ? A
R = (A, B, C, D, E) into (A, B, C) and
(A, D, E)Show that this decomposition is a lossless join decomposition if the following set F of functional dependencies hold:
A ? BC
CD ? E
B ? D
E ? A
10 M
2 (b)
What are the main architectures used for building parallel Databases? Give advantages and disadvantages of each.
10 M
3 (a)
Explain Security and Authorization in SQL.
10 M
3 (b)
Given a relation with eight attributes Proj_no, Proj_name, Emp_no, Emp_name, Job_class, Charge_hrs, Hrs_billed and Tot_charges.
Normalize it upto 3rd Normal form.
Normalize it upto 3rd Normal form.
10 M
4 (a)
Explain design and implementation issues in Mobile Database.
10 M
4 (b)
What is fragmentation? Explain different types of fragmentation in distributed database.
10 M
5 (a)
Explain object identity and type constructors with example.
10 M
5 (b)
Define Data warehouse. Explain architecture of data warehouse with suitable block diagram.
10 M
6 (a)
Consider a data warehouse for hospital, where there are three dimensions:
(i) Doctor (ii) Patient (iii) Time
and two measures-
(i) Count (ii) Charges
where charges is the fee that doctor charges a patient for visit.
Using the above example, describe the following OLAP operations:
(i) Slice (ii) Dice (iii) Rollup (iv) Drilldown
(i) Doctor (ii) Patient (iii) Time
and two measures-
(i) Count (ii) Charges
where charges is the fee that doctor charges a patient for visit.
Using the above example, describe the following OLAP operations:
(i) Slice (ii) Dice (iii) Rollup (iv) Drilldown
10 M
6 (b)
Explain various Extended features of ER Diagram such as aggregation,Generalization and Specialization with suitable examples.
10 M
Write short notes on (any two)
7 (a)
Spatial Databases.
10 M
7 (b)
OLAP Servers.
10 M
7 (c)
ODL Schema.
10 M
7 (d)
Comparison between OLTP and OLAP.
10 M
More question papers from Advanced Database Management Systems