IT Induction Flashcards
What is a database?
A database is a collection of both data and information that is organized in a logical fashion.
What is a relational database?
A relational database is a database in which data is split into multiple logical tables. These tables are linked together by common values.
What is a flat-file database?
A flat file database is a database where all data is stored in only one table.
What is a record?
A record is all the data about a person or object (e.g First Name, Last Name, Address, Income).
What is a field?
A field is a specific piece of data about a person or object (e.g Last Name).
What is a table?
A table stores records in a database.
What is a primary key?
A primary key is a field that is used to uniquely identify a record within a database.
What is a simple primary key?
A simple primary key is a primary key that is made up of a single field only. (e.g. CustomerID).
What is a compound primary key?
A compound primary key is a primary key that is made up of multiple fields combined together (e.g. First Name + Last Name + Date of Birth).
What is a secondary key?
A secondary key is a field that is used to index a table for much faster search results.
What is a foreign key?
A foreign key is a field in a table that is used to link multiple tables together.
What is referential integrity?
Every foreign key has a corresponding primary key. Referential intergrity uses this to make sure that there are no parentless records. Referential Integrity also allows for you to be alerted when you are deleting a record which has linked to another record.
