Databases & SQL Flashcards
What is a Primary Key ?
A unique identifier for each record
What is a database?
It is a computerised system that makes it easier to search for data
What is a table?
A collection of records for each theme
What is a field?
Categories for each piece data in a table
What is a record?
Data for one object, person or place
What is a relational database?
It is made up of more than one type of table
What is a foreign key?
It is the linking field in a foreign table when a relationship is made the foreign key becomes the primary key of a new table
What is manipulating?
Changing the data
What is a flat file database ?
It is a database stored in a flat file
Give an example of a field?
Age or Gender
Why could data redundancy be a problem ?
The same piece of data could be repeated
Why could data inconsistency be a problem?
The data could start being inconsistent
What does SQL stand for ?
Structured Query Language
What is data redundancy ?
It is where data is repeated in a database table
What is data inconsistency ?
If data is stored multiple times
