What are the six steps necessary to design a database for a set of requirements?
What will be an ideal response?
1. Read the requirements, identify the entities (objects) involved, and name the entities.
2. Identify the unique identifiers for the entities identified in step 1.
3. Identify the attributes for all the entities.
4. Identify the functional dependencies that exist among the attributes.
5. Use the functional dependencies to identify the tables by placing each attribute with the attribute or minimum combination of attributes on which it is functionally dependent.
6. Identify any relationships between tables.
You might also like to view...
Answer the following statements true (T) or false (F)
1. Numeric codes are much easier to sort than alphanumeric. 2. Keep codes uniform among, as well as within, programs. 3. When using codes in a GUI interface, they should only be selected using a check box. 4. If codes change frequently or are somewhat unstable, they should be stored as a database function in a GUI system.
You would place a chart on its own ________ if you planned to print it out separately or if the chart has a lot of detail
Fill in the blank(s) with correct word
A(n) ____________________ describes an association in which one or more classes make up the parts of a larger whole class.
Fill in the blank(s) with the appropriate word(s).
________ can most accurately be described as the command center of Office 2010
A) The Ribbon B) Backstage C) The status bar D) The Quick Access Toolbar