What steps should be followed when preparing to create a table?
What will be an ideal response?
When preparing to create a table, one should:
1. Identify the appropriate data type and length for each attribute
2. Identify the columns that should accept null values
3. Identify that columns that need to be unique
4. Identify all primary-foreign key mates
5. Determine default values
6. Identify any columns for which domain constraints, such as check, need to be stated
7. Create the table and any indexes using create table and create index statements
You might also like to view...
Section 548 of the Bankruptcy Code defines as fraudulent certain transfers made, or obligations incurred, within what specified time period?
a. 12 months b. 9 months c. 6 months d. 3 months e. 1month
One formal intervention method is ________, which allows negotiators to have considerable control over the process, but they have little or no control over outcomes.
Fill in the blank(s) with the appropriate word(s).
Which of the following is true of filtering?
A. Filtering aids effective communication by making a message more favorable to a receiver. B. The more vertical levels in an organization, the more opportunities there are for filtering. C. Filtering occurs at the individual level; the organization cannot encourage or discourage it. D. The use of e-mail increases filtering because communication is more direct.
A critical requirement of all learning organizations is that everyone feels and supports a compelling purpose.
Answer the following statement true (T) or false (F)