Guru Gobind Singh Indraprastha Vishwavidyalaya 2011 B.B.A Dbms - Question Paper
(Please write your Exam Roll No.) Exam Roll No.
___Second Semester |BBA| May-june-2011__
Paper Code: BBA/BBA(B&I)/BBA(TTM)108 \ teffr_Subject: Database Management System
Time : 3 Hours Maximum Marks :75
Note: Attempt any five questions.
Q1 (a) Discuss the advantages and disadvantages of DBMS over file processing system. (8)
(b) Draw and explain the architecture of DBMS. (7)
Q2 (a) Differentiate between network model and relational model. (6)
(b) Why is relational model more popular over other models of DBMS? (6)
(c) What is logical schema? (3)
Q3 (a) Explain how concurrency is handled by DBMS? (7)
(b) Explain the types of attributes represented in E-R model. How are the entity Sets different from relationship sets? (5+3=8)
Q4 (a) Construct an E-R diagram for hospital management system. By choosing your own entity and relationship sets. (7)
(b) Reduce down the above E-R model into the table structure. (8)
Q5 Consider the employee database. Emp (empno, ename, job, salary, hiredate, deptno)
Dept (deptno, dname, location) Give an expression in SCL for the following queries: (21/2x6=15)
(a) Display the empno and dname of the employee named Anit.
(b) Display the total salary of each deptno encluding , the employees who are clerk.
(c) Give 20 percent salary hike to all the employees, work in deptno 30.
(d) Create the table Emp.
(e) Insert the details of new employee in the Emp table.
(f) Display the name of the employee who is having maximum Salary.
Q6 (a) List and explain the Codds rules of DBMS. (8)
(b) What is referential integrity constraint? Explain. (4)
(c) How are the views created? Explain by giving the syntax. (3)
Q7 Differentiate between: (3x5=15)
(a) Functional dependencies and fully functional dependencies
(b) 3 NF and 2NF
(c) 2 NF and INF
(d) Data definition language and Data manipulation language
(e) Normalization and Denormalization.
Q8 (a) Explain by giving suitable examples, the working of set operators ie.
Union, Intersect, and Except. (5)
(b) What are the uses of forms in MS-Access? How are they created? (5)
(c) How are the aggegate operators deals with null values? (5)
************
|
Attachment: |
| Earning: Approval pending. |
