END TERM EXAMINATION
Database Management System
Time: 3Hrs Max. Marks: 75
Note: Attempt any five questions including Q No. 1 which is compulsory. Select one question from each unit.
Describe any five of the following: (5 x 5 = 25)
(a) Differentiate between strong and weak entity.
(b) Types of relationship in E-R diagram.
(c) ACID properties for a transaction.
(d) Selection and projection operation in relationship algebra.
(g) Aggregate functions in SQL.
(a) Explain data independence. What is the difference between logical and physical data independence. (6.5)
(b) Define database management system. What are the advantages of a DBMS? (6)
(a) What are various types of attributes? Explain with an example. Also draw the diagram. (6.5)
(b) What is DDL and DML, explain with an example? (6)
Consider the following table:
|Roll No.||Student Name||Shift||Contact No.|
Write queries for the following:
(a) Add result of student Mini assuming your own data. (1.5)
(b) Change the shift of a student 'Avi' to 'E' and contact No. as 2987. (1.5)
(c) Remove the result of student 'Rima' (1.5)
(d) Display the result of all students with their roll no., name and shift. (1.5)
(e) Show those students 'name in alphabetical order with their result who scored better marks in DBMS than DS'. (1.5)
(f) List the name of all students who have lowest marks in DBMS. (1.5)
(g) Show the result of 'Vinay' in all subjects. (1.5)
(h) List the names of all those students who have above the average of marks in Maths. (2)
(a) Describe various integrity constraints which can be implemented on a database. (6.5)
(b) Give purpose,syntax and example of the following: (3 x 2 = 6)
(i) ALTER TABLE
(ii) DROP TABLE
(iii) CREATE VIEW
Consider the following two tables T1 and T2, show the result of following operations: (12.5)
Table T1 Table T2
(a) T1 ⋈ T1-P = T2AT2
(b) T1 ⋉ T1-Q = T2AT2
(c) T1 ⋊ T1-R = T2CT2
(d) T1 ▷ T1-R = T2CT2
(e) T1 ∪ T2
(f) T1 ∩ T2
(a) Describe the steps to convert the basis ER model to Relational Database schema.
(b) Describe various joins in relational algebra with example.
What is concurrency transaction? What are the various techniques to control to problems due to concurrency of transactions? (12.5)
Describe the following terms in database management system.
(a) System Failure (3.5)
(b) Backup (3)
(c) Recovery (3)
(d) Authorization (3)