Flashcards
Database Terminology
Cards in this deck (12)
- 1TableA 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
- 3FieldA 'field' is one piece of data or information about a person or thing
- 4Data TypesA data type is how data is stored within a database
- 5Field LengthA field length is the necessary number of character spaces in a table/ form
- 6Primary KeyAll records in a database should have something unique to be identified by
- 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 makes sure that the relationship between two tables (e.g.) is synchronized for updating and deletion
- 9Relational DatabaseA database that uses a series of tables to store information. Contains related information and connected with each other
- 10ProductivityA measure of efficiency of an organisation or employee
- 11EntityA real world thing about which information needs to be stored and maintained. E.g. patients, doctors, treatments
- 12Entity Relationship DiagramsA diagram that illustrates the relationships between entities in a database
Information
- Description
- Flashcards on Database Terminology, created by 11lharris on 11/11/2014.
- Created by
- 11lharris
- Views
- 6
- Rating