CIS 515 STUDY Future Starts Here/cis515study.com CIS 515 STUDY Future Starts Here/cis515study.com | Page 13

4. Specify the components that would be required to hold timevariant 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.

Your assignment must follow these formatting requirements:
• Be typed, double spaced, using Times New Roman font (size 12),
with one-inch margins on all sides; citations and references must
follow APA or school-specific format. Check with your professor for
any additional instructions.
• Include a cover page containing the title of the assignment, the
student’s name, the professor’s name, the course title, and the date.
The cover page and the reference page are not included in the
required assignment page length.