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
JANUARY 2021 EXAMINATION

DAM 461: STATISTICAL DATABASE SYSTEM

Credit: 3 units

TIME ALLOWED: 2½ Hours

INSTRUCTION: Answer Question 1 and any other FOUR (4)

 

Questions

1a (i). What is the major difference between data and information? (2 marks)

1a (ii). What is a relational database? (2 marks)

1a (iii) Mention the two approaches to database systems and state their major difference. (2 marks)

1b (i). Define the following:

a. Data Model (1 mark)

b. Database schema (1 mark)

c. Database state (1 mark) Use the information below to answer question

1b (ii) UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a deliveryRoute.

1b (ii) Create an Entity Relationship diagram that captures this information about the UPS system. Be certain to indicate identifiers and cardinality constraints. (7 marks)

1c (i). Differentiate between statistical database and statistical DBMS? (2 marks)

1c (ii). Describe the Statistical Object Representation Model (STORM). (2 marks)

1c (iii). Explain the concept of the relationship between Query Denial and Information Leakage. (2 marks)

 

2a (i). Differentiate between a. Composite and Simple attributes (2 marks)

b. Single-valued and Multivalued attributes (2 marks) 2a (ii) State three functions of a current generation DBMS. (3 marks)

2b. Who is a database actor? List and describe the functions/roles of any four database actors you know? (5 marks)

 

3a.(i). State four advantages of using a DBMS. (4 marks)

3a (ii). Describe the following categories of DBMS languages:

a. Data Definition Language (1 mark)

b. Data Manipulation Language (1 mark)

3b. Explain the following models:

i. Relational Model (2 marks)

ii. Hierarchical Model (2 marks)

iii. Object-relational model (2 marks)

 

4a (i). Describe a client/server architecture. (2 marks)

4a (ii). Mention 2 examples of specialized servers. (1 mark)

4a (iii) State three functions of the database system utilities? (3 marks)

4b (i). What is an entity type? Differentiate between weak and strong entity types. (4 marks)

4b (ii) Give four examples of queries associated with the statistical Database? (2 marks)

 

5a (i). Explain the concept of perturbation. (3 marks)

5a (ii). What do you understand by The SPEA Smart Airport Statistical Data Management System (SMART STAT)? (2 marks)

5b (i). Differentiate between data confidentiality and statistical disclosure. (4 marks)

5b (ii). Describe the three kinds of data contained in a statistical database. (3 marks) 6a. Given the tables below:

What are the results of the following statistical queries?

i. count (Female · CS)
ii. sum(Female · CS, SAT)

iii. Count(Male · (CS + EE))

iv. max(Female · CS, SAT)

v. min(Male · (CS + EE)), GP)

vi. count(Male · Bio) (6 marks)

 

6b. Describe the following:

i) query restriction (2 marks)

ii) query size restriction (2 marks)

iii) partitioning (2 marks)


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