For More Quiz Questions click here to download Global Quiz on Google PlayStore

NATIONAL OPEN UNIVERSITY OF NIGERIA

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

CIT 844 ADVANCED DATABASE MANAGEMENT SYSTEMS – (2 Credits)

 Answer Question 1 and any other three questions. Time Allowed:2 Hours.

Total of 70, Question 1 is 25 marks and others 15 marks each

 

1(a) What is a multimedia database? (2mks)

1(b). Give two advantages and two disadvantages of OODBMS? (4mks)

1(c ) . Identify the primary advantage and disadvantage of distributed database system (2mks)

1(d) . Enumerate the desirable properties of a transaction in a database system. (4x ½mks = 2 marks)).

1(e ) . List the possible states of a user initiated transaction (2 mks).

1(f) Enumerate the levels where security measures must be taken in order to protect the database.

 (4 x ½ mks =2 marks))

1(g). List four possible operations of relational algebra (4mks)

1(h) List five examples of database systems.(5mks)

1(i ). Identify two anomalies that can be associated with bad database design. (2mks)

 

2(a)  Explain the following terms in database management system:

i. DML                              ii. DDL                   iii. Transaction    

iv. Concurrency control    v. Entity Relationship Model

(1 marks each)

2(b). List the types of normalization that can be applied to remove database design anomalies. (3mks)

2(c ). Using appropriate illustrations show how the ER Model (comprising entities, attributes of an entity, relationship sets, and attributes of relationship sets) is represented by means of an ER diagram.(7 mks)

 

3(a) What is a transaction and what is a task? (4mks)

  1. Using a simple transaction where a bank employee transfers N5000.00 from A's account to B's account, show the possible low level tasks involved in this transaction.(7 mks)

(c )Differentiate between deadlock prevention and deadlock avoidance. (4mks)

 

4 (a). Discuss each of the following concepts in the context of the relational data model giving examples where possible: (2marks each)

(i) attribute domain           (ii) attribute    (iii) tuple         (iv) degree

(b )Discuss each of the following terms: (2mks each)

            (i) data   (ii) database security (iii) database management system

( c) Identify the primary advantage and disadvantage of distributed database system (1 mks)

 

5(a). What is a data warehouse? (4mks)

(b). Explain the main characteristics of a data warehouse? (8mks)

(c). What is data mining? (3mks)


For More Quiz Questions click here to download Global Quiz on Google PlayStore


Select NOUN Past Questions & Answers by Faculties

Sciences

National Open University of Nigeria (NOUN) Faculty of Sciences Past Questions and Answers.

Education

National Open University of Nigeria (NOUN) Faculty of Education Past Questions and Answers.

Arts & Social Sciences

National Open University of Nigeria (NOUN) Faculty of Arts and Social Sciences Past Questions and Answers.

Law

National Open University of Nigeria (NOUN) Faculty of Law Past Questions and Answers.

Management Sciences

National Open University of Nigeria (NOUN) Faculty of Management Sciences Past Questions and Answers.

Health Sciences

National Open University of Nigeria (NOUN) Faculty of Health Sciences Past Questions and Answers.

Agriculture Sciences

National Open University of Nigeria (NOUN) Faculty of Agricultural Sciences Past Questions and Answers.

Select Project Topics & Materials by Categories

Accounting

Universities, Polytechnic's and Colleges of Education Accounting Project Topics and Materials.

Biology

Universities, Polytechnic's and Colleges of Education Biology Project Topics and Materials.

Business Education

Universities, Polytechnic's and Colleges of Education Business Education Project Topics and Materials.

Chemistry

Universities, Polytechnic's and Colleges of Education Chemistry Project Topics and Materials.

Computer Science

Universities, Polytechnic's and Colleges of Education Computer Science Project Topics and Materials.

Criminology & Security

Universities, Polytechnic's and Colleges of Education Criminology & Security Project Topics and Materials.

Economics

Universities, Polytechnic's and Colleges of Education Economics Project Topics and Materials.

Education

Universities, Polytechnic's and Colleges of Education Education Project Topics and Materials.

English/Linguistic

Universities, Polytechnic's and Colleges of Education English/Linguistic Project Topics and Materials.

Entrepreneurship

Universities, Polytechnic's and Colleges of Education Entrepreneurship Project Topics and Materials.

Environmental Science

Universities, Polytechnic's and Colleges of Education Environmental Science Project Topics and Materials.

Law

Universities, Polytechnic's and Colleges of Education Law Project Topics and Materials.

Marketing

Universities, Polytechnic's and Colleges of Education Marketing Project Topics and Materials.

Physics

Universities, Polytechnic's and Colleges of Education Physics Project Topics and Materials.

Political Science

Universities, Polytechnic's and Colleges of Education Political Science Project Topics and Materials.

Public Administration

Universities, Polytechnic's and Colleges of Education Public Administration Project Topics and Materials.

How to login to NOUN Elearn Portal

You can now use you matric number to login as your username and  password in a lowercase.

https://elearn.nouedu2.net/login/

Note that you are to change your passw...

Facebook posts