Data Types

Front 1

What is a Database?

Back 1

Databases are designed to offer an organized mechanism for storing, managing and retrieving
information. They do so through the use of tables.

Front 2

Identify different data types?

Back 2

logical/Boolean, alphanumeric/text, numeric
(real and integer) and date

Front 3

Define Logical/Boolean

Back 3

A field of this data type will only let you enter a 'Yes' or a 'No', Male or Female, On/Off

Front 4

Define alphanumeric/Text

Back 4

A field of this data type will accept text, numbers and symbols

Front 5

Define Numeric

Back 5

A field of this data type is used to store numbers

Front 6

Define date

Back 6

A field of this type stores days, months and years and Time.

Front 7

Describe what is meant by the key field

Back 7

Keys are crucial to a table structure for many reasons, some of which are identified below:
They ensure that each record in a table is precisely identified.
They help establish and enforce various types of integrity.
They serve to establish table relationships.

Front 8

Describe what is meant by the field

Back 8

Fields describe a single aspect of each member of a table

Front 9

Describe what is a record

Back 9

A table consists of records, and each record is made up of a number of fields.

Front 10

What are the difference between analogue data and digital data

Back 10

Analogue data is represented in a continuous form, as contrasted with digital data having
discrete values

Front 11

explain the need for conversion between analogue and digital data

Back 11

Since data is sent using variable currents in an analogue system, it is very difficult to remove
noise and wave distortions during the transmission. For this reason, analogue signals cannot
perform high-quality data transmission.
On the other hand, digital signals use binary data strings (0 and 1) to reproduce data being
transmitted. Noise and distortions have little effect, making high-quality data transmission
possible.