A database is a structured collection of data. It allows people to organise extract specific information in a way that meets their needs. Data is only stored once in a database which means no duplication of information.
| ID |
First Name |
Last Name |
Age |
House |
| 001 |
Jay |
Chou |
11 |
Yellow |
| 002 |
Jane |
Watson |
10 |
Red |
| 003 |
Will |
Smith |
13 |
Blue |
| 004 |
Max |
Verst |
12 |
Green |
| 005 |
Anna |
Maria |
11 |
Yellow |
Database Structure
- Entities: Each recorded item.
- Attributes: Details about the entity.
- Field: Columns used to capture attributes.
- Record: One row of details about an entity.
- Table: A set of field and records.
- Primary Key: Unique identifier for an entity.
Use of Data Types
| Text |
Number of characters. |
Short text/long text. |
| Character / Char |
A single character. |
Short text with a field size of one. |
| Boolean |
One of two values. |
True/False |
| Integer |
A whole number. |
A fixed formatted number with no decimal place. |
| Real |
A decimal number. |
Number formatted as decimal. |
| Date/Time |
Date and/or Time |
Date/Time |
Database Key Terms
- Data - Information within the database.
- Table - A structure in which data is stored.
- Flat - File database, a single table database.
- Index - A list of values or items.
- Query - A method of searching a database.
- Range - Start or End
- Presence - Checks if the data is enterd in specific field or not.
- Validation - This is checking that the correct type of data is entered.