Databases Flashcards Preview

Nat 5 Computing > Databases > Flashcards

Flashcards in Databases Deck (14)
Loading flashcards...
1
Q

What is a database file?

A

A file made up of records strong all the information on a particular subject

2
Q

What is a database record?

A

Stores all the information about one person / thing

Consists of fields

3
Q

What is a database field?

A

Stores one piece of information such as name or age

4
Q

Flat file database

A

Consists of one table

Repeated data

5
Q

Linked database

A

Separates data into different tables

Tables linked together

Prevents repeated data, deleting data and having to keep updating data

6
Q

Primary key

A

A field used to identify every record

7
Q

Foreign key

A

Primary key from one table appearing in another table to link the two together

8
Q

Valuation checks

A

Presence
Restricted choice
Field length
Range

9
Q

Presence check

A

Makes person enter something so field isn’t left blank

10
Q

Restricted choice

A

Cuts down on mistakes

Select option from menu

11
Q

Field length check

A

Restricts number of characters typed

12
Q

Range check

A

Makes sure data is within certain limits

13
Q

Advantages of searching and sorting

A

Easy to add new information

Easy to sort

Easy to search

14
Q

What does a database consist of?

A

Files
Records
Fields