T9: Databases

Question 1

What is a database?

Answer 1

A way of holding data in an organised way so that searching for data items meeting certain criteria is easy

Question 2

In a table, what is the name given to a row

Answer 2

Records
Each record will have identical record structures

Question 3

In a table, what is the name given to a column?

Answer 3

Fields
Each field has a defined field type, e.g. text, Boolean, numeric

Question 4

What is the format of an SQL statement?

Answer 4

SELECT - List the filed(s) you want to display

FROM - List the table the data will come from

WHERE - List search criteria here

ORDER BY - Sorts data in ASC or DESC order

Question 5

Write an SQL statement for finding the total number of female members in the ClubMember table

Answer 5

SELECT COUNT
FROM ClubMember
WHERE Gender = “F”

Question 6

Write an SQL statement for finding the total number of eruptions of volcanoes in Italy recorded in the Volcano table

Answer 6

SELECT SUM(TimesErupted)
FROM Volcano
WHERE County = “Italy”