Types

Question 1

Rows in a database are aka …?

Answer 1

Tuples

Question 2

Columns in a database are aka …?

Answer 2

Attributes

Question 3

What is an atomic type?

Answer 3

A type with no structure (i.e. a single thing, like a number, string or alphanumeric)

i.e. like an atom was originally thought, cannot be broken down further

Question 4

How do you write the type of an ordered pair, and what is it called?

Answer 4

A⊗B; Product Type

Example

(John, 28) has the type String⊗Number

Formally written:

(John, 28) : String⊗Num

Question 5

Write the type of the following labelled tuple:

(name: John, age: 28, address: Colchester)

Answer 5

[name: String, age: Num, address: String]

Question 6

True/False - A finite set may contain elements of different types.

Answer 6

False

All elements in a finite set must be of the same type.

Question 7

Give the type of the set

{1, 2, 3, 4, 5}

Answer 7

Set(Num)

Formally written

{1, 2, 3, 4, 5} : Set(Num)