Database Information Systems

Question 1

Attribute

Answer 1

the defined property of an entity.

Question 2

Centralised database

Answer 2

has all its data residing in one place

Question 3

data dictionary

Answer 3

a list of field names containing information about how the data in each field is to be constructed

Question 4

data integrity

Answer 4

the accuracy and reliability of data

Question 5

data matching

Answer 5

used to cross-link data- data is brought together from different sources and compared

Question 6

data quality

Answer 6

identifies how reliable and effective the data is in a database, involves the accuracy of the data

Question 7

data redundancy

Answer 7

where the same data is stored in two or more records or files, this is undesirable duplication of data. Redundant data takes up valuable space.

Question 8

data validation

Answer 8

the process of checking the validity of data at the data entry stage

Question 9

database

Answer 9

A database is a collection of related data, stored in such a way that meaningful information can be extracted. Files, records, fields and characters are the elements that make up the structure of data in a database.

Question 10

database administrator

Answer 10

the person who is responsible for the construction of a database and the supervision of operations connected with that database.

Question 11

distributed database

Answer 11

a database that consists of two or more files located at different sites on a computer network.

Question 12

entity

Answer 12

the specific thing about which data is collected and stored , separate tables in the schema indicate the entities

Question 13

file

Answer 13

a collection of related records: a record is a collection of related fields, a field is a subdivision of a record and a character is the smallest unit of data entered into a field

Question 14

flat-file database

Answer 14

a database system that operates on a single table of data

Question 15

foreign key

Answer 15

an attribute, which is the primary key of another table

Question 16

hyperlink

Answer 16

a piece of text or graphic that contains an embedded link to another piece of text, an image or another web page

Question 17

hypermedia

Answer 17

the storage of information using a set of documents that may contain text, number, images , audio and video

Question 18

hypertext

Answer 18

a system where documents can be cross-linked in such a way that you can navigate from one document to the next by clicking on hyperlinks, which are electronic connections

Question 19

metadata

Answer 19

information about data that provides a common ground for people working on a project at the same time

Question 20

online analytical processing ( OLAP)

Answer 20

a software tool that provides analysis of data stored in a database and is used in data mining

Question 21

online transaction processing( OLTP)

Answer 21

This refers to a class of systems that facilitates and manage transaction -oriented applications, typically for data entry and retrieval transaction processing.

Question 22

primary key

Answer 22

a field that stores data that uniquely identifies the record

Question 23

query by example ( QBE)

Answer 23

a visual method of query where the search criteria is entered into an empty record and the records meeting this criterion will be displayed

Question 24

query language

Answer 24

a non-procedural language, designed to allow the database user to ask questions of the database

Question 25

relational database

Answer 25

This works with multiple tables that are linked by key fields

Question 26

relationship

Answer 26

the way in which entities are related to one another- the key field is used to link entities

Question 27

schema

Answer 27

an organised plan of an entire database, showing where the data is found and the logical relationships