Data Processing Past Questions and Answers

(a) Explain the following database management terms; (i) entities (ii) attributes (iii) relationships
(b)(i) Define cardinality in database management.
(ii) Mention three cardinality relationships database management.

a. Figure 1 illustrates a part of a computer system,

(i) Identify the part labeled Y.
(ii) Sate;
I. The technology used in the part labeled Z.
II. The function of the labeled X.
III. one maintenance practice for the part labeled Z.

(b) Figure 2 shows a setup of a computer system. State one function of each of the parts labeled P, Q, R, S and T.
(c) Outline the steps taken to perform the following tasks in CorelDraw application;
(i) Insert a circular shape.
(ii) add caption "Happy Birthday" around the circular shape.
(iii) change the colour of the caption to green.

Table 1 shows the list of items and the quantity of the items needed by a student. The table was created on an MS Excel worksheet.
Use the table to answer questions 6(a)(i)-(iv)
Table 1

ITEM	QUANTITY
TEXTBOOK	12
BIRO	5
EXERCISE BOOK	18
PENCIL	3
CALCULATOR	2
ERASER	2

(a)Outline the steps to; (i) create a bar chart on the worksheet such that the items would be labeled on the chart and the percentage of each item included.
(ii) add to the table a new; A. column B. row
(iii) State one function in MS Excel that can be used to determine the item with the highest quantity.
(b) Outline the steps to add page border to a document using Art Design Tool in MS Word application.
(c) An MS Word document contains the phrase "WAEC Exam". Highlight the steps to link the phrase WAEC website (http://www.waec.org.ng).

The symbols dialog box of MS Word application is located on the ____________

Pressing the key combination Ctrl + J on a selected text in a Microsoft Word document would