Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
15 Cards in this Set
- Front
- Back
Database
|
Databases are designed to offer an organized mechanism for storing, managing and retrieving information.
|
|
What is a table(Data Base)?
|
A single store of related information. A table consists of records, and each record is made up of a number of fields
|
|
Key field
|
The records are sorted alphabetically by the name field
|
|
Record (Database)
|
Each record is made up of a number of fields. A record contains all the information about a single 'member' of a table.
|
|
What is a field?
|
Fields describe a single aspect of each member of a table.
|
|
Primary Key
|
It will uniquely identify each record. It may or may not provide information about the record it identifies
|
|
Data Type
|
This helps check for the wrong type of data being entered and makes sure the data is stored as efficiently as possible. It also means it will be sorted correctly.
|
|
Alphanumeric/text fields
|
A field of this data type will accept text, numbers and symbols
|
|
Numeric fields
|
A field of this data type is used to store numbers. Number fields are used to store numbers because the data will be sorted correctly
|
|
Two types of numeric field
|
Real - used for decimal numbers &
Integer - used for whole numbers |
|
Logical/Boolean fields
|
A field of this data type will only let you enter a 'Yes' or a 'No
|
|
Date/Time (Fields)
|
A field of this type stores days, months and years and Time.
|
|
Types of data base
|
Flat Model, Hierarchical Model, Relational Model and Network Model
|
|
Analogue data
|
It is represented in a continuous form, as contrasted with digital data having discrete values.
|
|
Digital data
|
A digital signal is a physical signal that is a representation of a sequence of discrete values
|