Rajiv Gandhi Proudyogiki Vishwavidyalaya(Technical University) B.E.(Fifth Semester) EXAMINATION,Nov.-Dec.2007 model question papers

Download Model question papers & previous years question papers

Posted Date: 03 Jul 2009      Posted By:: rajesh kale    Member Level: Silver  Points: 5 (₹ 1)

# 2007 Rajiv Gandhi Proudyogiki Vishwavidyalaya(Technical University) B.E. Computer Science B.E.(Fifth Semester) EXAMINATION,Nov.-Dec.2007 Question paper

 Course: B.E. Computer Science University/board: Rajiv Gandhi Proudyogiki Vishwavidyalaya(Technical University)

CS/IT - 503
B.E.(Fifth Semester) EXAMINATION,Nov.-Dec.2007
(Common for CS & IT Engg.)
DATABASE MANAGEMENT SYSTEM

Note : Attempt any five questions.All questions carry equal marks.

1.(a) Discuss main categories of data models.
(b) Explain the following terms :
(i) database schema
(ii) data independence
(c) Explain the difference between the two-tier and three-tier client/server architecture.
2.(a) Construct an E-R diagram for a hospital with set of patients and set of Medical doctors.
Associate with each patient a log of various tests and examinations conducted.
(b) What is subclass ? When is subclass needed in data modeling ? Explain is-a-relationship.
3.(a) Differentiate between the following :
(i) Super key and Primary key
(ii) Strong entity and weak entity
(iii) Generalization and specialization
(iv) User defined and attribute defined specialization
(b) Discuss entity integrity and referential integrity constraints. Why each is considered
important ?
4.(a) What is Union compatibility ? Why dothe Union,Intersection and Set-difference operations
require that the relations on which they are applied are union compatible ?
(b) Explain with respect to tuple calculus :
(i) tuple variable
(ii) range relation
(iii) atom formula
(iv) expression
(v) ?(Existential quantifier) and Univerasl quantifier.
5. Consier the following database with primary keys underlined :
Department(DNO, D Name, MGRENO,MGR start date)
Dept-location(DNO,Dlocation)
Project(PNAME,PNO,Plocation,DNO)
Works-ON(ENO,PNO, hours)
Dependent(ENO,dep-name,Sex,bdate,relationship)
For each of the following queries give expressions in SQL and relational algebra :
(a) Retrive the names of all employees in department
(b) List the names of all employees who have no dependents
(c) Retrieve the names of all employees who do not work on any project.
(d) Retrieve the average salary of all female employees.
(e) Find names of all employees who work on at least one projcet located in Hyderabad.
(f) Write SQL,DLL statements for the above database.
6.(a) Consider the relation R(A,B,C,D,E,F,G,H,I,J) and set of functional dependencies:
F={{A,B}->{C},{A}->{D,E},{B}->{F},{F}->{G,H},{D}->{I,J}}
What is the key of R, Decompose R in 2NF and 3 NF ?
(b) Explain the following :
(i) Trivial dependency
(ii) Lossless decomposition
(iii) Dependency preservation
(iv) Functional dependency
(v) Multivalued dependency
7.(a) Explain data fragmentation,replication and allocation techniques for distributed database
design.
(b) Explain join,natural join,outer join, full outer join, left outer join and right outter join
with example.
8. Write short notes on any four of the following :
(i) Oracle tools
(ii) Object oriented database design
(iii) Security constraint in DBMS
(iv) Role of DBA
(v) Database Management System Architecture.

### Related Question Papers:

• B.E.(Sixth Semester) EXAMINATION,No.-Dec.,2007

• B.E.(Sixth Semester) EXAMINATION, Dec. 2008

• B.E.(Sixth Semester) EXAMINATION, June. 2008

• B.E(Sixth Semester) EXAMINATION,Nov.-Dec.,2007

• B.E.(Sixth Semester) EXAMINATION, June, 2009(502)

• ### Categories

Submit Previous Years University Question Papers and make money from adsense revenue sharing program

Are you preparing for a university examination? Download model question papers and practise before you write the exam.

Looking for University or College admissions in India for 2022 - 2023 Academic Year?

Top Contributors
TodayLast 7 Daysmore...