D 41964 (Pages : 3) அகவை ப ல்ல क

व

FOURTH SEMESTER B.Sc. DEGREE EXAMINATION, APRIL 2018

(CUCBCSS-UG)

Computer Science

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

൭.൭ കം ട്ട

11.
12.

Time : Three Hours Maximum : 80 Marks

Part A
Answer all questions.
Each question carries 1 mark.

In the three level architecture of a DBMS, the level which describes how data is actually
stored is called ` 0

The person having central control over both data and programs accessing that data is
called

The person who proposed relational model is
statement is used in SQL to grant privileges to various users.

An expression in tuple relational calculus is of the form

A can be thought of as a table in which each tuple is a row, and all rows have the
same number of fields. #
An_______sis a condition that is specified on a database schema, and restricts the data that

can be stored in an instance of the database.
A relation schema R is in if whenever a nontrivial functional dependency X — A
holds in R, then X is a super key of R.

If all the operations in a transaction submitted to a DBMS are completed successfully and
their effect is recorded permanently in the database, then the transaction is said to be in
state.

. Te remove a database schema and all its tables, domains, and other elements, the

option is used along with the DROP command. `
(10 x 1 = 10 marks)

Part B
Answer all questions.
Each question carries 2 marks:

Define logical data independence.
Explain the syntax to create a view with the help of an example.

Turn ove: