ExamsSCHOOL OF SCIENCE AND TECHNOLOGY

National Open University Exam Past Question – CIT427 OCTOBER/NOVEMBER 2014 EXAMINATION

NATIONAL OPEN UNIVERSITY OF NIGERIA CIT427 DATABASE SYSTEM AND MANAGEMENT

14-16 AHMADU BELLO WAY, VICTORIA ISLAND LAGOS SCHOOL OF SCIENCE AND TECHNOLOGY OCTOBER/NOVEMBER 2014 EXAMINATION

 

COURSE CODE:     CIT427

COURSE TITLE:    DATABASE SYSTEM AND MANAGEMENT CREDIT UNIT:        3CREDIT UNITS

TIME:                        3 HOURS

INSTRUCTION:      ANSWER ANY FOUR QUESTIONS IN ALL

 

1a.       State the six basic operations a relational algebra can undergo                     [5.5 marks]

1b.       List and discuss three categories of Database Management Systems (DBMS) [12 marks]

 

  1. State and explain any six features of Database Management Systems (DBMS)

[17.5 marks]

 

3a.       Enumerate the four operations Data definition language (DDL) provides commands for

[3.5 marks]

3b.       Enumerate and write short note on the four categories of database users     [14 marks]

 

4a.       Define “SELECT” clause and give one example                                          [2.5 marks]

4b.       List and write short note on the five components of Data Structure             [15 marks]

 

5a.       Enumerate and discuss two types of Accessibility                                        [6 marks]

5b.       Write short note on the following:

  1. Dynamic Random Access Memory                                                   [3.5 marks] ii.        Static Memory                                                                                    [4 marks] iii.       Slow Write, Fast Read Storage                                                          [4 marks]

 

6a.       What is Existence Dependencies?                                                                 [2 marks]

6b.       Differentiate between a domain and a key constraint                                    [4 marks]

6c.       State the components and corresponding roles of an Entity Relationship Diagram

The   components    of    an    entity-relationship    diagram    and    their   [11.5 marks]

 

 

 

Related Articles

2 thoughts on “National Open University Exam Past Question – CIT427 OCTOBER/NOVEMBER 2014 EXAMINATION”

  1. Really enjoy your sit, it is very information regarding noun.
    pls can you send the following past question to my email via : otobong.ng@gmail.com
    CIT427 DATABASE SYSTEM AND MANAGEMENT OCT2015, MARCH2016
    CIT 425 OPERATIONAL RESEARCH OCT2015, MARCH2016
    CIT445 PRINCIPLE OF COMPILER OCT2015, MARCH2016
    THANKS n God bless

  2. PLS I NEED THE PAST QUESTIONS FOR
    CIT427 DATABASE SYSTEM AND MANAGEMENT MARCH/OCT2015, MARCH/OCT2016
    CIT 425 OPERATIONAL RESEARCH MARCH/OCT2015, MARCH/OCT2016
    CIT445 PRINCIPLE OF COMPILER MARCH/OCT2015, MARCH/OCT2016
    THANKS AND GOD BLESS YOU

Leave a Reply

Your email address will not be published. Required fields are marked *

Close