Information Technology Exam guide Unit 8: Information Processing


CXC Information Technology Guide: Unit 8

INFORMATION TECHNOLOGY EXAM GUIDE

UNIT 8: DATABASE MANAGEMENT

GENERAL OBJECTIVE:

On completion of this Section, students should develop expertise in the design of a database management system in the development of computer applications.

SPECIFIC OBJECTIVES:

The student should be able to:

CONTENT
1.

Explain the concept of a database;

Definition of database: repository of information;

collection of tables that are related to each other.

2.

Use terminology commonly associated with a database;

Database terminology: table (relation), entity, tuple, attribute,
primary key, secondary key, composite key, candidate key,
alternate key, foreign key.

3.

Distinguish among terminology associated with files and databases;

Row (tuple, record), column (attribute, field), key.
Data types: alphanumeric; numeric; data; logical.

4.

outline the advantages and limitations of databases;

Comparison with files with regards to: Speed;

Ad hoc queries;

standardization;

present multiple views of the same data.

5.

Create a database;

Table structure with at least three data types and populate with at least twenty-five records.

Use of wizard is prohibited.

6.

Modify a table structure;

Adding new fields, deleting fields, changing field definitions.

7.

sort a database;

Arranging data in numeric, alphabetic; or alphanumeric
format.

Report generating facilities of the database package, including use of sorting, grouping statistical and
summary features, for example, count, sum and average.

8.

Establish relationships;

Use of joins, merge tables/files.
9.

Qery a database using multiple search conditions;

Using more than one criterion; use of select, calculated fields.

10.

Determine the results of a search on a database given multiple conditions;

Two or more fields involving the use of relational and logical operators.

11.

Generate reports to the screen, printer and files.

Report generating facilities of the database package, including
use of sorting, grouping, statistical and summary features, for
example, count, sum and average.


Fivestar

guest (not verified) 5 May 2011 - 1:39pm

Just Revising For IT which is on the 12th of MAY.
I Look for any help necessary to pass my exams. =]

PAULETTE BROWN (not verified) 13 November 2013 - 12:13pm

helping my daughter to prepare for her examination

Add new comment

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

Image CAPTCHA
Enter the characters shown in the image.