Karteikarten
Database Technology
Karten in diesem Stapel (8)
- 1TablesA Table stores all of the records, information and data for a particular category or topic
- 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 typesThere are many different forms of data, which include alphanumeric or text, number, currency, date/time, auto number, logical and Boolean.
- 5Field lengthThis is a default field length, which is set up differently in different databases to keep the data base fast, efficient and organised.
- 6Primary KeyA Primary key is a way to uniquely identify data and this is sometimes called a 'key field'.
- 7Foreign keyA foreign key is used to link the 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.
Informationen
- Beschreibung
- Karteikarten am Database Technology, erstellt von 11swright am 11/11/2014.
- Erstellt von
- 11swright
- Aufrufe
- 5
- Bewertung