ISDD+Field+Types

media type="custom" key="28022377"


 * Video**

[|Advanced Data Types]


 * Questions**

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.

6. The manager of a running club wants to create a database to store the details of a 10km running competition.

Create a database with the following fields (and field types):
 * Name - the name of the runner (Text)
 * DOB - the date of birth of the runner (Date)
 * Start Time - each runner can choose the time of day they want to start their 10km run (Time)
 * Final Position - finishing position of the runner (Number)
 * Photo - image of the runner (Graphics)
 * Over 50 - checked if the runner is aged over 50 (Boolean)
 * Inspired by - link to web page of athlete who has most inspired runner (Link)
 * Adult - number of adult tickets required (Number)
 * Child - number of adult tickets required (Number)
 * Other - number of other tickets required (Number)
 * Total - total number of tickets (Calculated)

Now add 3 fictional records to the database.