13.

14.

15.
16.

18.
19.

20.

21.

197295

2 C 21505
Section B ( Short Essay Type Questions)

Answer at least five questions.

Each question carries 5 marks.

All questions can be attended.
Overall Ceiling 25.

What are the different types of data model ? Discuss about Database users.

Draw the ER diagram for a company needs to store information about employees (identified by
CEN, with salary and phone as attributes), departments (identified by Dno, with Dname and
budget as attributes), and children of employees (with Cname and Cage as attributes). Employees
work in departments, each department is managed by an employee, a child must be identified
uniquely by name when the parent (who is an employee ; assume that only one parent works for
the company) is known. We are not interested in information about a child once the parent leaves

the company

Write a short note on Relational model and Entity-Relationship model.

Define First Normal and fourth Form.

What is the use of group by clause ? And Discuss about the how to drop tables ?
How to use and working of the cursors - fetch, move, update, delete, close ?

Define decomposition and how does it address redundancy ? Discuss the problems that may be

caused by the use of decompositions ?
(5 x 5 = 25 marks)
Section C (Essay Type Questions)

Answer any one question.

The question carries 11 marks.
(a) Compare and Contrast, file Systems with DBMS ?
(b) What is the use of groupby and having clauses ? Explain with examples.
(a) How Passing and Returning data to and from Stored Procedures. Explain with example.

(b) What is an Attribute ? Explain types of attributes used in ER how it represented in ER
diagram ?

{1 x 11 = 11 marks]

197295