Databases

Question 1

Database

Answer 1

A structured system to hold data

Question 2

Relational Database

Answer 2

A database structured to recognize relations between stored items of information

Question 3

Flat File Database

Answer 3

A Flat file database is a database that stores data in a plain text file. Each line of the text file holds one record, with fields separated by delimiters, such as commas or tabs. While it uses a simple structure, a flat file database cannot contain multiple tables like
a relational database can.

Question 4

Entity

Answer 4

Any item about which data is stored e.g. Student, Pizza, Stock etc.

Question 5

Attribute

Answer 5

A feature of the entity

Question 6

Foreign Key

Answer 6

A unique identifier to each record held in the relational database

Question 7

Composite Primary Key

Answer 7

A combination of 2+ fields that act as a primary key

Question 8

Foreign Key

Answer 8

A way to build a relationship

between 2 tables, the foreign key is another tables primary key

Question 9

Secondary Key

Answer 9

A key that is indexed to allow for faster searching. There can be multiple secondary keys and they
don’t have to be unique.

Question 10

Inner Join

Answer 10

Combining columns from one + tables by using values common to each.