NATIONAL OPEN UNIVERSITY OF NIGERIA

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

Course Code: CIT 843                                                                                   

Course Unit: 2

Course Title:  DATABASE MANAGEMENT SYSTEMS

Instruction:                Answer Question 1 and Any other 3 Questions

Time Allowed:            2 Hours                                                                      

1a.       Define database.                                                                                             4 marks           

 b.        State the components of a Database System (DBS).                                     6 marks

  c.       Give a brief outline describing the database development process.               10 marks

d.         The data model is one part of the conceptual design process. The other is the function model. The data model focuses on what data should be stored in the database while the function model deals with how the data is processed. In the context of the relational database, what are the two models used for?    5 marks

2a.       Briefly explain what is a data model.                                                             3 marks

 b.        What is database design?                                                                                3 marks

 c.        Enumerate six of the characteristics of a good Data Model.                          9 marks

3a.       In the context of E-R model, define the following terms:

1. Relationship    i         Connectivity   ii        Cardinality                  6 marks

 b.        Outline the three basic types of connectivity for relations.                            9 marks

4a.       List five common features of database management systems.                       5 marks

 b.        Describe the four main parts of a Database Management System (DBMS).

                                                                                                                                    10 marks

 5.        Write SQL statements for the following:

 i.         To insert a tuple for Smith who has $1200 in account A-9372 at the SFU branch.

ii.         To increase all account balances by 5 percent.

iii.        To make two different rates of interest payment, depending on balance amount

iv.        Delete all loans with loan numbers between 1300 and 1500.            

v.         Delete all accounts at branches located in Surrey.                              15 marks

6a.       What do you understand by normalization?                                       2 marks

  b.       Explain the following terms                                                               

i. Functional dependency                                                        2 marks

ii. First, Second, and Third Normal Forms                             6 marks

 c.        Outline the process for transforming a 1NF table to 2NF.                 5 marks