Relational Databases and SQL

Question 1

What is a database?

Answer 1

A structured, persistent collection of data

Question 2

What are the 2 types of databases?

Answer 2

Flat file database
Relational database

Question 3

What is a flat file database?

Answer 3

A single table database - all information stored in 1 table
- very inefficient
- difficult to query as data is all in one table
- used for smaller/ trivial data sets
- data is often duplicated
- data inconsistency

Question 4

What is a relational database?

Answer 4

A database with more than one table which are connected together.
- eliminates data consistency and data redundancy

Question 5

What are the 5 database concepts?

Answer 5

Field
Record
Table
Primary key
Foreign key

Question 6

What is a field?

Answer 6

A name which refers to a single type of data from a database table

Question 7

What is a table?

Answer 7

A complete set of related records on the same topic/subject

Question 8

What is a record?

Answer 8

A set of related fields on a single entity within a database table

Question 9

What is a primary key?

Answer 9

A field in a table which is used to identify any record within the table