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...
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 |
Select NOUN Past Questions & Answers by Faculties
National Open University of Nigeria (NOUN) Faculty of Sciences Past Questions and Answers.
National Open University of Nigeria (NOUN) Faculty of Education Past Questions and Answers.
National Open University of Nigeria (NOUN) Faculty of Arts and Social Sciences Past Questions and Answers.
National Open University of Nigeria (NOUN) Faculty of Law Past Questions and Answers.
National Open University of Nigeria (NOUN) Faculty of Management Sciences Past Questions and Answers.
National Open University of Nigeria (NOUN) Faculty of Health Sciences Past Questions and Answers.
National Open University of Nigeria (NOUN) Faculty of Agricultural Sciences Past Questions and Answers.
Select Project Topics & Materials by Categories
Universities, Polytechnic's and Colleges of Education Accounting Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Biology Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Business Education Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Chemistry Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Computer Science Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Criminology & Security Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Economics Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Education Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education English/Linguistic Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Entrepreneurship Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Environmental Science Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Law Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Marketing Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Physics Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Political Science Project Topics and Materials.
Universities, Polytechnic's and Colleges of Education Public Administration Project Topics and Materials.
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...
The Flemish Ministry of Education and Training awards scholarships to highly talented international students who want to study a master's programme at a Flemish university, a school of arts or ...
Universities of the Coimbra Group offer short-term visits (generally 1 to maximum 3 months) to young African researchers from higher education institutions from Sub-Saharan Africa. The main aim of ...