Database Information Systems Flashcards Preview

Information Processes and Technology > Database Information Systems > Flashcards

Flashcards in Database Information Systems Deck (27)
Loading flashcards...
1
Q

Attribute

A

the defined property of an entity.

2
Q

Centralised database

A

has all its data residing in one place

3
Q

data dictionary

A

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

4
Q

data integrity

A

the accuracy and reliability of data

5
Q

data matching

A

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

6
Q

data quality

A

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

7
Q

data redundancy

A

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.

8
Q

data validation

A

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

9
Q

database

A

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.

10
Q

database administrator

A

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

11
Q

distributed database

A

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

12
Q

entity

A

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

13
Q

file

A

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

14
Q

flat-file database

A

a database system that operates on a single table of data

15
Q

foreign key

A

an attribute, which is the primary key of another table

16
Q

hyperlink

A

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

17
Q

hypermedia

A

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

18
Q

hypertext

A

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

19
Q

metadata

A

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

20
Q

online analytical processing ( OLAP)

A

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

21
Q

online transaction processing( OLTP)

A

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

22
Q

primary key

A

a field that stores data that uniquely identifies the record

23
Q

query by example ( QBE)

A

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

24
Q

query language

A

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

25
Q

relational database

A

This works with multiple tables that are linked by key fields

26
Q

relationship

A

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

27
Q

schema

A

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