What Are The Steps To Follow When Preparing To Create A Table?

Subject not found.

1.	What Are The Steps To Follow When Preparing To Create A Table?
Answer» 1. Identify the data type, LENGTH, and precision for each attribute. 2. Identify the columns that can ACCEPT a null value. 3. Identify the columns that need to be unique. 4. Identify primary and related FOREIGN KEYS with the parent table being created before the child. 5. Determine default values. 6. Determine where the DOMAIN values are that need to be constrained. 7. Create the indexes. 1. Identify the data type, length, and precision for each attribute. 2. Identify the columns that can accept a null value. 3. Identify the columns that need to be unique. 4. Identify primary and related foreign keys with the parent table being created before the child. 5. Determine default values. 6. Determine where the domain values are that need to be constrained. 7. Create the indexes.

Answer»

1. Identify the data type, LENGTH, and precision for each attribute.

2. Identify the columns that can ACCEPT a null value.

3. Identify the columns that need to be unique.

4. Identify primary and related FOREIGN KEYS with the parent table being created before the child.

5. Determine default values.

6. Determine where the DOMAIN values are that need to be constrained.

7. Create the indexes.

1. Identify the data type, length, and precision for each attribute.

2. Identify the columns that can accept a null value.

3. Identify the columns that need to be unique.

4. Identify primary and related foreign keys with the parent table being created before the child.

5. Determine default values.

6. Determine where the domain values are that need to be constrained.

7. Create the indexes.

Discussion