1e Data Types ***

Question 0

The airline has a database of customer names and addresses.
(a)
Identify the most appropriate data type for the following fields:
House Number (1 mark)
Price of tickets (1 mark)
Telephone no (1 mark)

Answer 0

House number - Text/Alphanumeric/String (1)
Price -Real / Currency (1)
Phone no - Text/Alphanumeric/String (1)

Question 1

A company has created a customer database
Identify the most suitable data type for the following fields in the order database.
Order completed?
Total cost of order (2 marks)

Answer 1

Order completed - Boolean (1) yes/no (1) true/false (1)

Total cost of order - Real (1) currency (1)

Question 2

Select the most appropriate data type for the following fields from the database and give a reason for your choice:
House no (2 marks)
Price per hour (2 marks)
HireID (2 marks)

Answer 2

1 for data type, 2nd for reason:
House Number
Text/String/Alphanumeric (1)
House numbers can be a number or text eg 2c (1).
Price Per Hour
Currency/Real (1)
Price contains decimal places/allow calculations (1)
HireID
Autonumber/number/text/string/alphanumeric (1)
Dependent on data type given – unique (1)

Question 3

State the most appropriate data types for the following fields in the bookshop database
ISBN (1 mark)
Book price(1 mark)
Number of pages (1 mark)

Answer 3

ISBN -Text/string/alphanumeric (1)
Book prices - Real/Currency (1)
No of pages - Integer (1)