8508893
Beschreibung
Mindmap von Brandon Davies, aktualisiert more than 1 year ago
|
Erstellt von Brandon Davies
vor mehr als 7 Jahre
|
|
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
Möchten Sie kostenlos Ihre eigenen Mindmaps mit GoConqr erstellen? Mehr erfahren.