Fichas

Tables

11jbennison Inglés 8 fichas

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 one thing.
3FieldsA 'field' is one piece of data or information about a person or a thing.
4Data TypesThe type of data that you will use (currency, text, number)
5Field LengthChoose the maximum amount of characters per cell.
6Primary KeySomething unique to easily identify it (Number of the item in an Argos catalogue)
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 integrityThis makes sure that you don't delete a record which is related to another one.