0417 Database: Data Types

The number of children in a class

• Alphanumeric

• Numeric (Integer)

• Boolean

• Numeric (Real)

• Text

The gender of a person

• Alphanumeric

• Boolean

• Date

• Text

• Numeric (Real)

The precise weight of an item

• Numeric (Integer)

• Numeric (Real)

• Text

• Alphanumeric

• Boolean

A person's first and second names

• Alphanumeric

• Boolean

• Text

• Date

• Numeric (Integer)

Someones Birthday

• Alphanumeric

• Numeric (Integer)

• Text

• Date

• Boolean

a Yes/No question

• Text

• Alphanumeric

• Numeric (Real)

• Date

• Boolean

Which field is best suited to a Boolean data type?

• Equipment Type

• Number in stock

• Buy online (Y/N)

• Last Ordered

Which field is best suited to a Numeric data type?

• Equipment Type

• Number in Stock

• Buy Online (Y/N)

• Last Ordered

Which field is best suited to a Date data type?

• Equipment Type

• Number in Stock

• Buy Online (Y?N)

• Last Ordered

Which field is best suited to a Alphanumeric data type?

• Equipment Type

• Number in Stock

• Buy Online (Y/N)

• Last Ordered