STUPIDSID
1 (a)
Define data and information. Also explain advantages of DBMS.
7 M
1 (b)
Write SQL or Relational algebra statement for following.
Student( Enrno, name, courseId, emailId, cellno)
Course(courseId, course_nm, duration)
1) Add a column city in student table
2) Find out list of students who have enrolled in 'computer' course.
3) List name of all courses with their duration.
4) List name of all students start with 'a'.
5) List emailId and cellno of all mechanical engineering students.
Student( Enrno, name, courseId, emailId, cellno)
Course(courseId, course_nm, duration)
1) Add a column city in student table
2) Find out list of students who have enrolled in 'computer' course.
3) List name of all courses with their duration.
4) List name of all students start with 'a'.
5) List emailId and cellno of all mechanical engineering students.
7 M
2 (a)
List and explain various data models used for database design.
7 M
2 (b)
Draw an ER diagram for Event Management System.
7 M
2 (c)
What is Entity set? Also define Relationship set. List and explain all the symbols used to draw ER Diagram.
7 M
3 (a)
Define followings: Functional dependency, Trivial functional dependency, multivalve functional dependency, 1NF, BCNF, 3NF, 4NF.
7 M
3 (b)
What is normalization? Normalize following relation up to 3NF.
Bank(acno, cust_name, ac_type, bal, int_rate, cust_city, branchId, branch_nm, br_city)
7 M
3 (c)
What is relational algebra? List and explain Fundamental and additional relational algebra operators.
7 M
3 (d)
What is aggregate function? Explain all aggregate functions with the help of example.
7 M
4 (a)
What is need of lock in DBMS? Explain shared lock and exclusive lock with the help of example.
7 M
4 (b)
What is transaction? Draw and explain life cycle of transaction.
7 M
4 (c)
List and explain various issues while transactions are running concurrently in DBMS.
7 M
4 (d)
Explain two phase locking protocol. Also list advantages of this protocol.
7 M
5 (a)
Why we need to do recovery in DBMS? Explain various method use for that.
7 M
5 (b)
What is data dictionary? What it stores? How can this information be useful in DBMS.
7 M
6
Explain following with example(Any 4)
PL/SQL block, Cursor, Trigger, Stored procedure, View
14 M
More question papers from Database Management Systems