Database Designer Training Exercise: Creating User-Defined Columns for the New Child Table

In this section you will add four columns to your child table:

·            ACTIVITY_TYPE

·            ACTIVITY_DATE

·            DESCRIPTION

·            COMMENTS

1.    Under the “USR_SEQUENCE” Column Name a new “USR_” column displays.
After the “USR_” prefix, enter ACTIVITY_TYPE.

Whenever you begin work on a column with the “USR_” prefix, a new, blank “USR_” row is automatically added.

2.    In the next row, enter “ACTIVITY_DATE” after the “USR_” prefix.

3.    Change the Data Type for USR_ACTIVITY_DATE to “datetime”.

4.    In the next row, enter “DESCRIPTION” after the “USR_” prefix.

5.    Change the Precision from “50” to “100”.

6.    In the next row, enter “COMMENTS” after the “USR_” prefix.

7.    Change the Precision from “50” to “100”.
Your table should now look like this: