Flashcards
Database terminology
Cards in this deck (13)
- 1DatabaseA database is a collection of information comprised of tables, forms, queries and reports.
- 2TablesA table stores all records using fields of a particular category
- 3RecordAll data about one 'thing'
- 4FieldField is one piece of data about every record.
- 5Data TypesThings like Boolean or numeric, the form in which the data takes
- 6Field lengthMost will think about field length and have a default
- 7Primary keyA unique key to every record to identify which of two records with the same name it is.
- 8Foreign 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.
- 9Referential IntegrityWhat stops you from deleting related records e.g. no 'orphan' records
- 10Relational DatabaseA database that consists of many tables each withholding extensive information about the entity which will then use foreign keys to refer to relationships.
- 11Entity Relationship DiagramA diagram illustrating the relationships between entities
- 12ProductivityThe efficiency of an organisation or business using some standardised measure.
- 13EntityA real world thing represented by a table. (records are examples of entities with a table) E.G. Mrs. Smith is a patient (patient = entity, Mrs. Smith= example
Information
- Description
- Flashcards on Database terminology, created by C.Innes on 11/11/2014.
- Created by
- C.Innes
- Views
- 6
- Rating