Rajasthan Technical University 2007 B.Tech Computer Science and Engineering DATABASE MANAGEMENT SYSTEMS (CSE- 305) (New) - Question Paper
Saturday, 25 May 2013 01:00Web
Instruction to Candidates:
1) part - A is compulsory.
2) Attempt any Four' ques. from part - B.
3) Attempt any 2 ques. from part - C.
Maximum Marks: 60
part - A
Q1)
a) describe the-term candidate key.
b) What is public key encryption?
c) elaborate heterogeneous databases?
d) elaborate weak entity sets?
e) What is data inconsistency?
f) describe the term atomic domain.
g) What is B- Tree indexing?
h) describe the term relational algebra.
i) List any 2 non procedural programming' languages?
j) elaborate row triggers?
Sectfon - B
Q2) discuss how daugling kinds may arise and what issues they may cause?
Q3) discuss the difference ranging from physical and logical data independence?
Q4) Suppose that we decompose the schema R = (A, B, C, D, E) into
(A, B, C) (A, D, E) .
show that this decomposition is a loss less -join decomposition' if the subsequent set F of functional dependencies holds
A~BC,
CD~E,.
B~D,
E~A.
Q5) Construct an E.R diagram for a car insurance company whose customers own 1 or more cars every. every car has associated with it zero to any number of recorded accidents.
Q6) discuss the concept of concurrency control based on Time stamp ordering.
part - C
Q7) What is normalization? discuss different normal forms with the help of suitable examples.
Q8) Consider the subsequent relational data.
employee (person-name, street, city)
works (person-name, company - name, salary)
company (company-name, city) .
manager' (person-name, manager-name)
provide an expression in relational algebra and SQE for the subsequent queries. (a) obtain the names of all employees who work for 1st Bank Corporation. (b) obtain the company that has the most employees
(c) obtain. the names of all employees who work for 1st Bank Corporation and earn more than $10000. .
(d) obtain the company that has the smallest payroll
(e) obtain names and cities of residences of all employees who work for 1st Bank Corporation.
Q9) Write short notes on the following:
(a) Nested Transactions.
(b) Granularity of data items.
(c) Cost base optimization.
Earning: Approval pending. |