Monday, September 5, 2016
S.B. Roll No.
RELATIONAL DATABASE MANAGEMENT SYSTEM
Duration : 3 Hrs.
Note: Any required data not explicitly given , may be suitably assumed and stated.
1. Chose the correct or best alternative in the following
a. Which of the following is a reason to model data?
i. Understand each user’s perspective of data
ii. Understand the data itself irrespective of the physical representation
iii. Understand the use of data across application areas
iv. All of the above
b. If an entity can belong to only one lower level entity then the constraint is
c. The common column is eliminated in
i. Theta join
ii. Outer join
iii. Natural join
iv. Composed join
d. In SQL. Testing whether a sub query is empty is done using
e. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute value are
i. Distinct values
ii. Cannot have NULL
iii. Both (a) and (b)
iv. Same is primary key
f. The cost of reading and writing temporary files while evaluating a query can be reduced by
i. Building indices
iii. Join ordering
iv. None of the above
g. A transaction is in _________ state after the final statement has been executed.
i. Partially committed
iv. None of the above
h. In multiple granularity of locks SIX lock is compatible with
i. The statement that is executed automatically by the system as a side effect of the modification of the database is
j. The normal form that is not necessarily dependency preserving is
Note: Answer all questions. Each question carries 6 marks.
a. Briefly describe the different kinds of users of a DBMS.
b. Explain the following. Give an example.
ii. Weak entity set
iii. Attribute inheritance
i. Define the concept of aggregation. Give two example where this concept is useful.
ii. Define the following
1. A relation.
2. Atom of domain relational calculus.
d. Derive the union rule, decomposition rule and the pseudo transitivity rule using the three Armstrong’s axioms.
e. Define multi valued dependency. What do understand by trivial multivalve dependency?
f. Given R(A, B, C, D,E ) and M the set of multi valued dependencies
i. A →→ BC
Is R in 4NF? Justify your answer. If is not, decompose R into 4NF
Note: Attempt any two questions
3. Given the relations R(A, B, C) and S (C,D,E,F) given an expression in tuple relational calculus that is equivalent to each of the following.
a. II ABC (R)
b. σ E=10(S)
c. R∞ S
d. R S
4. Given the relations Staff (staff No, position, salary) and property ( number , rent, staff No) given below. The staff looks after a given property.
staff No position salary
Number rent staffno
PA14 5000.00 SL21
PG4 6000.00 SG5
PL94 10000.00 SL21
Give the result table for the following SQL queries
i. SELECT position, COUNT(Staff NO) AS POS, my count
ii. SELECT staff no
WHERE salary>(SELECT AVG(salary) FROM staff)
iii. SELECT staff no
GROUP BY staff no
iv. INSERT INTO staff no
VALUES (‘SG33, assistant’)
a. Describe the four main ways of optimizing disk block access.
b. Describe the algorithm for updating indices for a single level index when a record is
What will be the modification if there are multilevel indices.
punjabtechnicaluniversity.blogspot.in Roll No......................... ... Total No. of Questions : 07] ...
Roll No……….. Total No. of Questions: 07 B.Com. (Sem.-1 st ) FINANCIAL ACCOUNTING Subject Code: BCOP-101 Paper ID: [B1101] ...
punjabtechnicaluniversity.blogspot.in Click Here for Syllabus of B-Tech 1st Year . http://ptu.ac.in/userfiles/file/engg_syllab/1st_and_...
Business Organisation and Management, Question Paper of B.Com 1st Semester,Download Previous Years Question Paper 2Roll No…….. Total No. of Questions: 07 B.Com (Sem.-1 st ) BUSINESS ORGANIATION AND MANAGEMENT Subject Code: BCOP-102 (2011 &a...
Roll No……. Total No. of Questions:07 B.COM (Sem.-1 st ) BUSINESS MATHEMATICS SUBJECT CODE: BCOP-104 (2011 Batch) PAPER ID: ...
punjabtechnicaluniversity.blogspot.in Roll No. ...................... Total No. of Questions : 13] ...
punjabtechnicaluniversity.blogspot.in Master Of Technology (M-Tech) Syllabus SYLLABUS FOR MASTER OF TECHNOLOGY (M-Tech) Br...
punjabtechnicaluniversity.blogspot.in Click Downlink for Dowload of Scheme and Syllabus of B.Com. Professional Batch 2011onwards ht...
B.Sc. IT (402) (S05) / 102 (New) (Sem. - 4th) BASIC MATHEMATICS – I, Punjab Technical University, PTU, Question paperpunjabtechnicaluniversity.blogspot.in Roll No. ................. Total No. of Questions : 13] ...
punjabtechnicaluniversity.blogspot.in Roll No . ............ Total No. of Questions : 07) ...