ict

what is a record
all the data about the person or thing, made up of fields
1 of 19
what is a field
single piece of data about a thing or person. many fields makes up a record
2 of 19
what is a primary key
a field within a database thatg enables a record to be uniquely identified
3 of 19
what is a foreign key
a field in one table which is also the primary key of another table, used to estalish links
4 of 19
what is an entity
a object of rhe real world that can be related to an ict system
5 of 19
what is an attribute
a single item of which represents a fact about an enitity
6 of 19
what is a relationship
the way in which entities and attirbutes are linked together
7 of 19
what is data redudancy
the unecessary duplication of data
8 of 19
what is data intregreity
the correctness and acuracy of data
9 of 19
what is data consistancy
the realtionship between data inut, data processing and data output and anyh other related data
10 of 19
what is data independence
when the data and applicartio used to store it are seperate so you can change the dataand the application will remain the same
11 of 19
what is data normalisation
a staged mathematical process which removes groups of repeated data and inconsistancies
12 of 19
Name some of the features of a flat file database
very simple to set up. can be set up usin g a spreadsheet or database software. simple storage syste tgat consists of only one table
13 of 19
name some of the features of a realtional database
groups of tables linked together by primary and forign keys. hieracy of passwords. access rights. redundancy.
14 of 19
what is data mining
interrogating te data to find patterns in the data stored in the warehouse
15 of 19
what is data warehousing
a large collection of archived data used for decision making
16 of 19
what is distrubuted database
a singlem, logical databse whose parts are physcially located in more than one place. each location is accesible across a network
17 of 19
advantages of distributed database
faster response to user queries. easy to bnackup and copy from one server to another. not dependent on one central pool of data.
18 of 19
disadvanatges of distributed database
increased costs due to expensive communication lines. heavy reliant o communicatons and networks. more risk to hackers the more data is transfered
19 of 19

Other cards in this set

Card 2

Front

what is a field

Back

single piece of data about a thing or person. many fields makes up a record

Card 3

Front

what is a primary key

Back

Preview of the front of card 3

Card 4

Front

what is a foreign key

Back

Preview of the front of card 4

Card 5

Front

what is an entity

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all databse systems resources »