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
SEPTEMBER 2020 EXAMINATION

COURSE CODE: CIT 843

COURSE TITLE: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

CREDIT UNIT: 2

TIME ALLOWED: 2 HOURS

INSTRUCTION: ANSWER QUESTIONS 1(ONE) AND ANY OTHER THREE (3)

 

1a) State five (5) advantages of DBMS? (2½marks)

b) What is the relationship between Forms and Sub-form? When is sub form required?(3½mks)

c.) Write the full meaning of the following acronyms:

(i) DDL,

(ii) RDBMS,

(iii) ODBC,

(iv) SQL

v) XML (5 marks)

d) Write short notes on the following SQL Scalar functions:

(i) LCASE(),

(ii) ROUND (),

(iii) NOW(),

(iv) FORMAT () (4 marks)

e) What are the strengths and limitations of Traditional Mainframe Architecture?( 5 mks)

f) Why did Relational database systems replace the File based systems (5marks)

 

2a) Describe the term "Database Architecture"? Explain the features of File sharing database system architecture? (8marks)

b) Describe extensively any seven (7) Microsoft Access data types? (7 marks)

 

3a) What is a database management system? Using appropriate diagram, show the contents of a database system (6½marks)

b) With suitable illustration describe the concepts of normalization justify the need for normalization and the first three normal forms (8½marks)

 

4a) Describe in detail the following terms:

(i) Two-Tier Client/Server Architecture

(ii) N-Tier Client/Server Architectures,

(iii) Open Database Connectivity (ODBC) (9marks)

 

4b) Give suitable explanations on the following relational database concepts (6marks)

i. Relational algebra

ii. Relational operations

iii. Union (A U B)

iv. Intersection (A n B)

v. Difference (A – B)

 

5a.) What is database recovery? How can you prevent deadlocks from occurring? (4mks)

b.) Discuss extensively with examples the importance of Database security (4mks)

c) What is the function of SQL GRANT and REVOKE commands? Using the SQL GRANT and REVOKE statements, exercise the following rights on the relation below. (7mks) Table: Table name - EMPLOYEES

STAFF ID STAFF NAME LOCATION SALARY STATUS WORK EXPERIENCE ACCESS RIGHTS
001 Jason Birmingham Britain Paid 5 User Data
002 Richard Banks Britain Unpaid 5 User Data
003 Frederick Hanson France Paid 4 Full Rights
004 Butler Steaks Italy Paid 3 Full Rights
005 Francois Mason France Paid 3 Full Rights

 


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