Fichas
Database Terminology
Fichas del conjunto (8)
- 1TableA table stores all of the records for a particular category.
- 2RecordsA record is all of the data or information about one person/thing.
- 3FieldsA field is one piece of data or information about one person or thing.
- 4Data TypesA data type can be Text, Numeric, Currency, Date/Time, Autonumber, Logical/Boolean.
- 5Field lengthA field length is how large set of data should be.
- 6Primary keyEvery single record in a database has something to uniquely identify it, this is Primary key
- 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 foreign key to ensure that there is no orphan records, it prevents you from deleting related records
Información
- Descripción
- Fichas sobre Database Terminology, creado por 11tellis el 11/11/2014.
- Creado por
- 11tellis
- Visitas
- 4
- Valoración