DATABASE MANAGEMENT SYSTEMS

Email: smu.assignment@gmail.com

Mob: +919741410271 / +918722788493

Part One:
Multiple choices:

1. The normal language of database is:

a. PHP
b. SQL
c. C++
d. Java

2. DDL, a database system language:

a. Creates table
b. Manipulates table
c. Cannot work with table
d. None

3. Symbol for one to one relationship is………………………………………………………

4. HDBMS stands for:

a. Hello DBMS
b. Hierarchical DBMS
c. Hyper DBMS
d. High DBMS

5. In Anti joining of R►S means ……………………………………………………………

Part Two:

1. What are “Foreign Keys”?

2. Differentiate between ‘DBMS’ and ‘RDBMS’.

3. Write the syntax to insert charts into a table from another table.

4. What are ‘Armstrong’s Axioms’?

5. Write short ‘Boyce-Codd Normal Form (BCNF)’.

Section B: Long Questions (40 marks)

1. Elaborate the testing of Serializability techniques with example.

2. Explain the working of lock manager.

3. What is deadlock? How is a deadlock detected? Enumerate the method for recovery from the deadlock.

4. Explain why a transaction execution should be atomic. Explain ACID properties, considering the following transaction.

Ti: read (A);

A : = A- 50;

Write (A);
Read (B);
B : = B + 50;
Write (B)

Section C: Applied Theory

1. The HR manager has decided to raise the salary for all the employees in department number 30 by 0.25. Whenever any such raise is given to the EMPLOYEES, a record for the same is maintained in the EMP-RAISE table. It includes the employee number, the date when the raise was given and the actual raise. Write a PL/SQL block to update the salary of each employee and insert a record in the EMP-RAISE table.

2. Retrieve the salesman name in ‘New Delhi’ whose efforts have resulted into atleast one sales transaction.

Table Name: SALES-MAST

Salesman-no	Name	City
B0001	Puneet Kumar	Varanasi
B0002	Pravin Kumar	Varanasi
B0003	Radha Krishna	New Delhi
B0004	Brijesh Kumar	New Delhi
B0005	Tushar Kumar	Allahabad
B0006	Nitin Kumar	Allahabad
B0007	Mahesh Kumar	Gr. Noida

Table Name: SALES-ORDER

Order-no	Order-date	Salesman-no
S0001	10-Apr-07	B0001
S0002	28-Apr-07	B0002
S0003	5-May-07	B0003
S0004	12-Jun-07	B0004
S0005	15-Jul-07	B0005
S0006	18-Aug-07	B0006