Fichas
Database Terminology
Fichas del conjunto (8)
- 1TablesA table stores all of the 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 a person or thing.
- 4Data TypesData comes in many forms: Numerical, Alphanumeric, Currency, Date/Time, Autonumber and Logical/Boolean.
- 5Field LengthFields usually have default lengths, E.g. passwords usually have to be 6 characters.
- 6Primary KeyIt is important that every single record in a database has something to uniquely identify it and this is called the 'Primary Key' or sometimes the '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 IntegrityReferential Integrity prevents you from deleting related records.
Información
- Descripción
- Fichas sobre Database Terminology, creado por 11ccollins el 11/11/2014.
- Creado por
- 11ccollins
- Visitas
- 6
- Valoración