Annamalai University 2010-4th Sem B.E Computer Science and Engineering , (ester) coec-404 database management systems (new regulation) - Question Paper

B.E. DEGREE EXAMINATION,2010
(COMPUTER SCIENCE AND ENGINEERING)

(FOURTH SEMESTER)

COEC-404 DATABASE MANAGEMENT
SYSTEMS
(NEW REGULATION)

(FOR THE STUDENTS JOINED 2007-08 AND AFTER )
MAY] [TIME:3HOURS]
Maximum : 60 marks
Answer any 1 full ques. every Unit All ques. carry equal marks.
UNIT-I
1.Explain the system architecture of database management systems with
neat diagram.
[marks 12]
2.Draw an ER Diagram for library management and identify
primary key,foreign key , multi-valued attribute and derived attribute.
[marks 12]
UNIT-II
3. discuss about join kinds and its conditions.
[marks 12]
4.(a)What is trigger ? What is the need of the trigger ?
Give example in SQL. [marks 6]
(b)What are the nested sub-queries ? discuss with examples
[marks 6]

UNIT-III
5 (a) How do you preserve the dependency in the database ?
[marks 6]
(b) describe the subsequent :

(i) BCNF [marks 3]

(ii) DkNF [marks 3]

6. With suitable example , explain about the functional dependencies.
[marks 12]
UNIT-IV
7. How to arrange the files in DBMS ?
[marks 12]
8. (a) What is primary index ? elaborate the kinds of indices?
[marks 12]
(b) discuss the structure of B+tree.
[marks 6]
UNIT-V
9.(a) Differentiate the persistent programming languages
with other languages.
[marks 6]
(b) How to measure the query cost ?
[marks 6]
10.Explain in details about data storage and query processing
distributed database . provide example .
[marks 12]

Earning:   Approval pending.