8508893
Description
Mind Map by Brandon Davies, updated more than 1 year ago
|
Created by Brandon Davies
over 7 years ago
|
|
Database Terminology
- Table
- DEFINITION: A table stores all of the records for a particular category
- DEFINITION: A table stores all of the records for a particular category
- Record
- DEFINITION: A record is all of the data or information about one person or one thing.
- DEFINITION: A record is all of the data or information about one person or one thing.
- Field
- DEFINITION: a 'field' is one piece of data or information about a person or thing.
- DEFINITION: a 'field' is one piece of data or information about a person or thing.
- Data Types
- Boolean
- one of two values
- True or false
- True or false
- one of two values
- Integer
- a whole number
- 346
- 346
- a whole number
- String
- alpha numerical words
- monkey
- monkey
- alpha numerical words
- Date/Time
- Date or time of day
- 12/3/2019 or 12:00pm
- 12/3/2019 or 12:00pm
- Date or time of day
- Real
- a decimal number
- 11.32
- 11.32
- a decimal number
- Boolean
- Primary key
- DEFINITION: unique identifier for a record in a table
- DEFINITION: unique identifier for a record in a table
- Foreign Key
- DEFINITION: A foreign key is used to link tables together and create a relationship.
- DEFINITION: A foreign key is used to link tables together and create a relationship.
- referential integrity
- prevents from deleting related records, it is used when matching primary and foreign keys
- prevents from deleting related records, it is used when matching primary and foreign keys
Want to create your own Mind Maps for free with GoConqr? Learn more.