Flashcards
database termonology
Cards in this deck (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 thing
- 4Data typesA data type can be either: Text, currency, number, date/time, auto number, or Boolean.
- 5Field lengthA field length is how large a set of data should be , for example post code
- 6Primary keyevery single record in a database has something to uniquely identify it, this is called primary key, e.g student ID
- 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 a record that is related to another one.
Information
- Description
- Flashcards on database termonology , created by 11zadal on 11/11/2014.
- Created by
- 11zadal
- Views
- 12
- Rating