Data+Types+questions

Data Types
1. VideoHitz DVD rental shop stores details about films for rent in a database.

State the most suitable data type for each of the fields.

2. A database of footballer players has the following fields:
 * Name
 * Date of Birth
 * Position
 * Goals scored
 * Height (m)

State the most suitable data type for each of the fields Date of Birth and Height.

3. A database of mail order customers includes the following fields:
 * Account Name
 * Account Number
 * Credit Limit
 * Date of Last Order
 * Value of Last Order

State the most suitable data type for each of the fields Credit Limit and Date of Last Order.

4. A database of employees at a company includes the following fields.
 * Name
 * Employee Number
 * Date of Birth
 * Sex (M or F)
 * Start Date
 * Years Service

State the most suitable data type for each of the fields Sex, Start Date and Years Service.

5. Customer details are stored in a database. Here is some sample data:

State the data types of the fields Name, DOB and MOB.