Assignment 4 Database Modeling and Normalization

Imagine that you work for a consulting firm
that offers information technology and database services. Part of its core
services is to optimize and offer streamline solutions for efficiency. In this
scenario, your firm has been awarded a contract to implement a new personnel
system for a government agency. This government agency has requested an
optimized data repository for its system which will enable the management staff
to perform essential human resources (HR) duties along with the capability to
produce ad hoc reporting features for various departments. They look forward to
holding data that will allow them to perform HR core functions such as hiring,
promotions, policy enforcement, benefits management, and training.
Using this scenario, write a three to four
(3-4) page paper in which you:

Determine the steps in the development of an
effective Entity Relationship Model (ERM) Diagram and determine the possible
iterative steps / factors that one must consider in this process with
consideration of the HR core functions and responsibilities of the
Analyze the risks that can occur if any of
the developmental or iterative steps of creating an ERM Diagram are not
Select and rank at least five (5) entities
that would be required for the development of the data
Specify the components that would be
required to hold time-variant data for policy enforcement and training
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.
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.
Diagram at least five (5) possible entities
that will be required to sustain a personnel solution. The diagram should
include the following:

Dependency diagrams
Note: The graphically
depicted solution is not included in the required page length.
Your assignment must follow these formatting

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.
Include charts or diagrams created in Excel,
Visio, MS Project, or one of their equivalents such as Open Project, Dia, and
OpenOffice. The completed diagrams / charts must be imported into the Word
document before the paper is submitted.Use this template APA_Template_With_Advice_(6th_Ed) .doc sample doc Assignment 4.docx

Related Posts

Quality Writing Features

Price Start $10
  • 24/7 Customer Support
  • All Subject Areas
  • Money-Back Guarantee
  • Timely Delivery
  • Originality report
  • Confidentiality guaranteed

Ordering Homework Writing Service

You can get our ideal online homework help services with four easy steps. All you have to do is inform us of your requirements. Immediately we will match with a specialist in your academic discipline. After that, we will track your order, review it to ensure it meets your requirements, and submit it to your email.


Submit Requirements

Fill in your assignment instructions on the order form


Writer match

Immediately you contact us for homework help; we will assign your assignment to an academic expert.


Quality review

We have a team of editors, who will thoroughly review your assignment, ensuring there are no errors before submission


Get Your Completed Paper

Once we have completed the assignment, we will deliver it to your account. Additionally, we will send a notification to your email.



Budget-friendly writing services



We don’t share our client’s information with a third party



We write every assignment from scratch

Amazing Homework Writing Features

Once you consult us for homework help online services, you will attest to why we are among the USA's best essay writing services.

Read on and find out some of the features that make our services superlative.

Free Homework Writing Services

Free plagiarism checker

You can confirm that the content you get is original for free using our plagiarism checker.

Free samples

We offer unlimited access to our essay homework samples.

Free title page and bibliography

Once you place an order, we format it accordingly without demanding additional charges.

Free unlimited revisions

We offer free unlimited revisions until your assignment is of your desired quality..

Free editing and proofreading

We have a team of specialized editors who review your assignment before submission.

Free customer support

You can track the progress of your homework for free.

Request for Homework Writing Service Today!

We have over 500 homework writing experts, ready and waiting to help you improve your writing skills