NATIONAL OPEN UNIVERSITY OF NIGERIA

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

Course Code:               CIT843                                   

Course Title:               Introduction to Database Management System

Course Credit              Unit: 2

Time Allowed:             2 Hours

Instruction:                  Answer Question 1 and any other three questions

Question 1

1. State two merits and demerits of Traditional Mainframe Architecture      (6 marks)
2. What are the three features that could be used to describe metadata    (3 marks)
3. What do you understand by Foreign Key Domain?                                       (3 marks)
4. Enumerate four limitation of file-based system                                             (4 marks)
5. Briefly discuss the following:                                                                              (6 marks)

1. Values Are Atomic         
2. The Sequence of Columns is Insignificant

(iii)         File and Printer Server

6. Explain "Non-repeatable read" in SQL transaction                                        (3 marks)

Question 2

1. Critically explain the roles of database administration in Database Security System? (6 marks)
2. Describe the four main rules that Authorization should take into account?              (9 marks)

Question 3

1. Briefly describe four kinds of action queries                         (6 marks)
2. Write down the twelve (12) steps required in creating Append Query?            (9 marks)

Question 4

1. Discuss the concept of Open Database Connectivity (ODBC)     (10 marks)
2. State five advantages of a Database Management System (DBMS)         (5 marks)

Question 5

1. Data integrity is enforced in the relational model by entity and referential integrity rules. Critically compare Entity Integrity and Referential Integrity            (8 marks)

Explain the concept of generalization hierarchy in relation to database management(7 marks)