Keywords for Databases Flashcards
What is a Database?
Method for storing data in an organised manner
What is a Table?
The structure in which the databases data is stored and organised
What is a Field?
A single attribute of an item or object
What is a Primary Key?
A field used to uniquely identify every record in the database
What is a Foreign Key?
It’s a primary key from one table that appears in another table to link the two together
What is a Relation Database?
A database that stores related information in seperated tables
What is a Flat File Database?
A database that consists of one table
What is Data Inconsistency?
The same data exists in different formats in multiple tables
What is an Entity?
A person place or an object (something that exists)
What is Data Redundancy?
When the same piece of data exists in multiple places
What is Referential integrity?
Logical dependancy of a foreign key on a primary key (refers to the relationship between tables)
What is an Entity relationship diagram?
Graphical representation that depicts relationships among people, objects, places, concepts, or events in an infromation technology query (IT) system
What is SQL?
Search Query Language
