2007 Rajiv Gandhi Proudyogiki Vishwavidyalaya(Technical University) B.E. Computer Science B.E.(Fifth Semester) EXAMINATION,Nov.-Dec.2007 Question paper
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 :
Employee(ENO,DOB,,ADDRESS,SEX,SALARY,NAME,DNO SUPER END).
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.
Return to question paper search
|