Databases and SQL

Question 1

what is a database?
what is a flat-file database?
what is a relational database?

Answer 1

• a database is where you can store data in an organised way, allowing data to be found easier as well.
• a flat-file database is where there is only one table to store data.
• a relational database is where it has more than one table and linked using key feilds.

Question 2

what is data redundancy?

what is data inconsistency?

Answer 2

• where data is repeated in a database table.

- links to data redundancy. if data is repeated, is it always the same data?

Question 3

what is a table?
what is a field?
what is a record?

Answer 3

• a collection of records for a specific theme.
• categories for each piece of data in a table.
• data for one object, person or place.

Question 4

what is a foreign key?

what is a primary key?

Answer 4

• when a column in one table is the same to another in a different table.
• the field that uniquely identifies a record