Fichas
Database Terms
Fichas del conjunto (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.
Información
- Descripción
- Fichas sobre Database Terms, creado por 11pmbaji el 11/11/2014.
- Creado por
- 11pmbaji · nov 2014
- Actualizado
- 19 feb 2016
- Visitas
- 5
- Valoración