Databases

?
  • Created by: jess2513
  • Created on: 27-11-19 12:38
Data Types
Text, Auto Number, Number, Date/Time
1 of 13
Text
letters, numbers, punctuation
2 of 13
Number
Numbers only
3 of 13
Date/Time
Dates and Times
4 of 13
Auto Number
Starts at 1 and counts up automatically
5 of 13
Flat file database
a database that only uses one table
6 of 13
Relational datbase
a database that uses multiple tables linked with keys
7 of 13
Record
a record is multiple fields of information stored about each person
8 of 13
Field
a piece of information about a person
9 of 13
database
A database is a place where data that is stored in a structured way.
10 of 13
advantages
Things are easy to find as it’s structured It can store a lot of information in a way that is cohesive and comprehensive for the reader It helps to decrease mistakes and human error (on a computer)
11 of 13
disadvantages
Can sometimes over-complicate things There is a limit of storage that can be input Human error
12 of 13
Primary Key
the link between tables
13 of 13

Other cards in this set

Card 2

Front

letters, numbers, punctuation

Back

Text

Card 3

Front

Numbers only

Back

Preview of the back of card 3

Card 4

Front

Dates and Times

Back

Preview of the back of card 4

Card 5

Front

Starts at 1 and counts up automatically

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »