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...
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)
(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)
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 ...