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.


4
Average: 4 (1 vote)
Your rating: None
PAULETTE BROWN's picture
PAULETTE BROWN (not verified)
Information Technology

helping my daughter to prepare for her examination

PAULETTE BROWN's picture
guest (not verified)
Information Technology

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

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
2 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.