G061 - Data Types questions

1. / A theatre company produces two plays a month. A single computer is used to book seats for the different performances.
The theatre company has decided to develop a new bookings database.
Fill in the table below identifying an appropriate field name for each data type. The first one has been done for you.
Data Type / Field Name
String / Surname
Date
Boolean
Number
/ [3]

2512 June 2005 Q6

2. / A driving school stores data about its customers.
For each field name given below, give an appropriate data type.
(a) / Telephone Number / [1]
(b) / Address Line 1 / [1]
(c) / Passed Theory Test? / [1]
2512 January 2006 Q1
3. / A cinema has collected information on its films in order to know how to improve audience figures.
Once collected, the data will be put into a database.
Identify suitable data types for the following fields:
(a) / Certificate rating / [1]
(b) / Number of performances / [1]
(c) / Price of ticket / [1]

2512 June 2006 Q1

4. / A travel company uses a database to hold customer details.
(a) / Customer ID / [1]
(b) / Customer Postcode / [1]
(c) / Customer Telephone Number / [1]

2512 June 2007 Q3

5. / For the following set of data give an appropriate data type.
(a) / First name / [1]
(b) / New customer / [1]
(c) / Telephone number / [1]

2512 June 2008 Q6

6. / An airline has a database of customer names and addresses.
Identify the most appropriate data type for the following fields:
(a) / House number / [1]
(b) / Price of tickets / [1]
(c) / Telephone number / [1]

G061 June 2009 Q2

7. / A company has decided to write a database to store information about its sales
The telephone number field in the CUSTOMER entity has the data type text.
Explain why text has been chosen as the data type for the telephone number. / [2]

G061 January 2010 Q4

8. / A company has created an order database to store customer orders.
Identify the most suitable data type for the following fields in the order database
(a) / Order completed? / [1]
(b) / Total cost of order / [1]

G061 June 2010 Q4

9. / Progressville ia a small village and is trying to raise money by hiring out its village hall. They have set up a committee to oversee the project.
The committee has asked a company to create a database that it can use to store details about the hire of the hall.
Select the most appropriate data type for the following fields from the database an give a reason for your choice:
(a) / House Number
(b) / Price Per Hour
(c) / HireID / [6]

G061 June 2011 Q3

10. / State the most appropriate data types for the following fields in a bookshop database:
(a) / ISBN
(b) / Book Price
(c) / Number of Pages / [3]

G061 January 2012 Q8

11. / A hospital stores patient records.
Give the most suitable data type for each of the fields shown in the table below and state why you have chosen that data type.
/ [6]

G061 June 2012 Q8

12. / EJO is an art gallery that displays and sells the work of artists. EJO also provides guided tours of the gallery.
Part of the tour database is shown below:

State the most appropriate data type for the following fields in the tour database.

(a) / Number in Party / [1]
(b) / Paid? / [1]
(c) / Give two advantages of using the autonumber data type for the TourID. / [2]

G061 January 2013 Q2