Fichas
Database Terminology
Fichas del conjunto (8)
- 1TableA table stores all the information/records for a particular category.
- 2RecordsA record is all of the data or information about one person or thing.
- 3FieldsA field is one piece of data or information about one person or thing.
- 4Data TypesData comes in different forms. These can include: numerical, alphanumeric, currency, date/time, autonumber & logical/Boolean.
- 5Field LengthDefault lengths are set up in order to fulfil it's purpose for the specific data input. For example, 7 characters for a post code.
- 6Primary KeyA primary key is a way to uniquely identify data. This is sometimes called a 'Key Field'.
- 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 integrityIt prevents you from deleting related records.
Información
- Descripción
- Fichas sobre Database Terminology, creado por 11cdownes el 11/11/2014.
- Creado por
- 11cdownes
- Visitas
- 5
- Valoración