C 80866 (Pages : 2)

~ 1168۰ | [1 1

FOURTH SEMESTER (CUCBCSS—UG) DEGREE EXAMINATION, APRIL 2020
Computer Science

BCS 4B 06—FUNDAMENTALS OF DATABASE MANAGEMENT SYSTEM AND RDBMS

(2014 Admissions)
Maximum : 80 Marks

Time : Three Hours
Part A

Answer all questions.
Each question carries 1 mark.

, we mean known facts that can be recorded and that have implicit meaning.

1. By

2. VDL for definition Language.

3. The description of a database is called database

4. The basic set of operations for the relational model is relational

5. The TABLE command is used to specify a relation by giving it a name and specifying
its attributes and initial constraints.

6. The command can be used to drop named schema elements, such as tables, domains or
constraints.

7. Ifa relation schema has more than one key, each is called a —————— key.

if whenever a nontrivial functional dependency from X to A

8. Arelation schema R is in
holds in R, then X is a super key of R.

9. A binary lock can have states or values.
locked item is also called share-locked because other transactions are allowed to read

10. A

the item.
(10 x 1 = 10 marks)

Part B (Short Answers)

Answer all questions.
Each question carries 2 marks.

11. What is DBMS ?
What are the duties of DBA ?

12.
What is the use of UPDATE command ?

13.
Turn over