NATIONAL OPEN UNIVERSITY OF NIGERIA

UNIVERSITY VILLAGE, PLOT 91, CASDASTRAL ZONE, NNAMDI AZIKIWE EXPRESS WAY, JABI, ABUJA.
FACULTY OF SCIENCES
JANUARY 2018 EXAMINATION

CIT 844 – Advanced Database Management System (2 Credits)

Instruction: Attempt Question 1 (25 marks) and any other three (15 marks each)

Time: 2¹/₂ Hours.

1.(a) Define the term “SQL Statement” with examples (7 marks)

1. (b) Write brief notes on the following with examples:

1. Integrity Constraints
2. Encryption
3. XML
4. Data Warehouse
5. Data Mining            (3 marks each = 15 marks)

1.(c ) Enumerate three XML syntax Rules(3 marks)

2(a ) Identify three properties of a transaction.(3 marks)

2(b) Define any four of the following:

1.   Read authorization
2.  Insert authorization
3.  Update authorization
4.  Delete authorization
5.  Index authorization
6.  Resources authorization
7.  Alteration authorization
8. Drop authorization

( 2 mark each = 8 marks)

2(c) Explain the term “Transaction” with examples (4 marks)

3(a) Briely discuss in writing the following:

1. Dead lock
2. Data recovery
3.  SQL

(2  marks each)

3(b).Describe a Multimedia Database with its types (7 marks)

3(c )What are the three (3) causes of data loss from database. (6  marks)

4. (a) Describe with diagram the steps involved in database design (6 marks)

4.(b) Write short notes on the following:

1. Data Integrity
2. Data Security
3. Data Validation

(2marks each)

4. (c). Define the following Set operations in terms of relationUNION, INTERSECTION, and DIFFERENCE. (3 marks)

5(a) Define Distributed Database? (4 marks)

5(b)Describe the term “Open Source Software” and outline three merits (8 marks).

5(c)Enumerate three (3) advantages of Object Oriented Database Management System(3marks)

6(a) The term “Relational Database” differs from traditional Database define it with examples  (5 marks)

6(b) Create Six (6) students’ tuples with the following attributes:

1. Name
2. Address
3. Age
4. Sex
5. Phone Number (6 marks)

6(c )Enumerate  and explain  three  basic update operations on relational Database (4 marks)