ந | 3 ee பட வா தத த ததை இ

C 3969 (Pages : 2)

व

அலது 10 ३०१४०

FOURTH SEMESTER B.Sc. DEGREE EXAMINATION, APRIL 2016
(CUCBCSS-UG)
Core Course—Computer Science
BCS 4B 06—FUNDAMENTALS OF DATABASE MANAGEMENT SYSTEM AND RDBMS
Time : Three Hours - - Maximum : 80 Marks
Part A

Answer all the questions.
Each question carries 1 mark.

A centrally controlled, integrated and logically organized data is known ‏ل قق‎
In SQL, the command that Iets you to add one or more fields in an existing table is

specifies the predefined set of possible values an attribute can take.

A set of one or more fields used to uniquely identify a record in table is known as

‎ஆ‏ مع ہرم

‎In DBMS, the language used by the DBA and database designers for schema definition is

‎6. ———— is a person who has central control over the data and programs that access data in a
DBMS.

‎relational operation selects tuples from a relation satisfying a given condition.

‎

‎normal form is based on the concept of transitive dependency. —
9. The type of lock which allows us to perform write operation is ~
‘10. A———— is a PL/SQL block that fires or executed in response to a specific event in the database.
(10 x 1 = 10 marks)
Part B ध

‎Answer all the questions.
Each question carries 2 marks.

‎11. What is a DBMS ? What are its components ?
12. What do you mean by data independence ?
13. Explain the concept of weak entity sets.
14. Explain the use of ORDER BY clause of SQL.
15. Define the term functional dependency.
(5 x 2 = 10 marks)

‎_Turn over