CIS 515 Course Great Wisdom / tutorialrank.com CIS 515 Course Great Wisdom / tutorialrank.com | Seite 13

4. Specify the components that would be required to hold time-variant
data for policy enforcement and training management.

5. Diagram a possible 1:M solution that will hold salary history data,
job history, and training history for each employee through the use of
graphical tools in Microsoft Word or Visio, or an open source
alternative such as Dia. Note: The graphically depicted solution is not
included in the required page length.

6. Plan each step of the normalization process to ensure the 3NF level
of normalization using the selected five (5) entities of the personnel
database solution. Document each step of the process and justify your
assumptions in the process.

7. Diagram at least five (5) possible entities that will be required to
sustain a personnel solution. The diagram should include the
following:

a. Dependency diagrams

b. Multivalued dependencies

Note: The graphically depicted solution is not included in the required
page length.