Databases Flashcards
What is a database file?
A file made up of records strong all the information on a particular subject
What is a database record?
Stores all the information about one person / thing
Consists of fields
What is a database field?
Stores one piece of information such as name or age
Flat file database
Consists of one table
Repeated data
Linked database
Separates data into different tables
Tables linked together
Prevents repeated data, deleting data and having to keep updating data
Primary key
A field used to identify every record
Foreign key
Primary key from one table appearing in another table to link the two together
Valuation checks
Presence
Restricted choice
Field length
Range
Presence check
Makes person enter something so field isn’t left blank
Restricted choice
Cuts down on mistakes
Select option from menu
Field length check
Restricts number of characters typed
Range check
Makes sure data is within certain limits
Advantages of searching and sorting
Easy to add new information
Easy to sort
Easy to search
What does a database consist of?
Files
Records
Fields
