Databases

Question 1

What is a database?

Answer 1

A database is a structured way to store data so that it can be retrieved using queries

Question 2

What do database fields meed to have?

Answer 2

A data type

Question 3

What are flat file databases

Answer 3

Databases that store a single table of data in a text file

Question 4

Advantages and Disadvantages of flat file databases

Answer 4

Ad- Easy to set up
Dis-Hard to manage larger data sets
Data repeated more often leading to more inconsistencies and redundancies making searching and sorting more difficult

Question 5

What is a primary key?

Answer 5

A file that is unique for each record in the table

Eg.ID number

Question 6

What is data repeated in a table know as?

Answer 6

Redundancy

Question 7

What is the same data written in different ways in the same field (eg. ‘Five’ and ‘5’) called?

Answer 7

Inconsistency

Question 8

What is a relational database?

Answer 8

A database with multiple tables, with links know as relationships

Question 9

Advantages and disadvantages of relational databases?

Answer 9

Ad- Less repetitions in the same table reducing inconsistencies and data redundancy.Easier to manage larger sets of data
Dis-Initially harder to set up

Question 10

What is a foreign key?

Answer 10

A field in a table that references the primary key of another table

Question 11

Relationship types

Answer 11

One to one (eg one owner to one dog)
Many to many (eg many books to many authors)
One to many (eg many kids to one teacher)