Karteikarten
Database Terms
Karten in diesem Stapel (8)
- 1TableDatabases store one type of data or information in tables, in a particular category.
- 2RecordA record is all of the data or information about one person or one thing.
- 3FieldA 'field' is one piece of data or information about a person or thing.
- 4Data typesA type of data which would suit a certain field: text, number, currency, auto-number, date/time, logical/Boolean/yes or no/true or false
- 5Field lengthA 'limited' amount of characters for a certain field.
- 6Primary key (Field key)A single record in a database has something unique to identify it
- 7Foreign keyA foreign key is used to link tables together and create a relationship. It is a field in one table that is linked to the primary key in another table.
- 8Referential integrityReferential integrity uses every foreign key, which has a matching value corresponding to a primary key, to ensure that there are no orphan records i.e. it prevents you from deleting related records.
Informationen
- Beschreibung
- Karteikarten am Database Terms, erstellt von 11pmbaji am 11/11/2014.
- Erstellt von
- 11pmbaji · Nov 2014
- Aktualisiert
- 19 Feb 2016
- Aufrufe
- 5
- Bewertung