Databases and SQL Flashcards
What is a Primary Key?
A Unique identifier of each record
What is a Database?
A database is an organized collection of structured information or data.
What is a table?
A table is a collection of records for a specific theme
What is a Field?
A field are categories for each piece of data in a table
What is a Record?
A record is data for one person, place or object. They allow data values of different types that relate to each other to be stored together instead of in different arrays.
What is a Foreign Key?
In a relational database, the foreign key stores a reference to the primary key from another table, creating the relationship between tables and allowing entities to be stored separately, but still be related to each other.
What is Data Redundancy?
Data redundancy is created within a database when the same piece of data is held in several places.
What is Data Inconsistency?
Data inconsistency is an irregularity in data or information
What is a flat file database?
A flat-file database is a database of just one table.
What is a Relational Database?
Relational Databases allow data to be separated and connected across several tables.
What is Data mining?
Data mining is a term used to describe analysing large amount of data to predict future events and trends.
What does SQL stand for?
SQL stands for Structured Query Language.
