Discuss about the database modeling and normalization

Assignment Help Database Management System
Reference no: EM131377821 , Length: 4

Assignment : 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 client.

Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are not performed.

Select and rank at least five (5) entities that would be required for the development of the data repositories.

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

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. 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

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.

Include charts or diagrams created in a drawing tool with which you are familiar. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

Recognize the historical development of database management systems and logical data models.

Explain the fundamentals of how data is physically stored and accessed.

Compose conceptual data modeling techniques that capture information requirements.

Use technology and information resources to research issues in the strategic implications and management of database systems.

Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.

Reference no: EM131377821

Questions Cloud

Summarise the industry and market background for case : After reading and analysing the case 'Chester & Kent Craft Beer' Based on the information provided in the case, summarise the industry and market background for Chester & Kent Craft Beer
Is jones entitled to regain ownership of the 2007 car : Jones thereupon sued Tate for the return of the 2007 car. Is Jones entitled to regain ownership of the 2007 car? Explain.
What is the decision as to roys action against royal motors : What is the decision as to (a) Roy's action against Royal Motors, Inc., and its counterclaim against Roy; and (b) Roy's action against Marks?
Calculate the pitch of the spring at the free length : A compression spring has squared ends and is made of carbon steel wire. The mean coil diameter is .812 in., and the wire diameter, d = 0.088 in. The coil outer diameter is 0.90 in. The spring has a free length of 10.312 in., and 29 total coils.
Discuss about the 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 t..
What is the strongest argument against reviving compression : What is the strongest argument in FAVOR OF reviving the compression chiller line? What is the strongest argument AGAINST reviving the compression chiller line?
Who will prevail and why : When the company refused to do so, Jones brought an action to recover the $1,425, and the company set up a counterclaim of $1,500 for expenses it incurred in repairing the car. Who will prevail? Why?
Can mary cancel the contract and recover the amount paid : Also, Mary demanded that Rebecca return the money paid under the contract. Rebecca refused the tender and declined to repay any portion of the money paid to her by Mary. Can Mary cancel the contract and recover the amount paid to Rebecca? Explai
Which coil deflects to zero pitch first : A force is applied to compress the spring, and the stresses always remain in the elastic range.

Reviews

Write a Review

 

Database Management System Questions & Answers

  How can you drop a table from your database that has one or

how can you drop a table from your database that has one or more other tables referencing it with foreign keys?no words

  Make sure to identify all the entities and their attributes

Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes).

  Network upgrade imagine that you are the administrator for

imagine that you are the administrator for a small accounting company which currently employees 200 people. the ceo

  Determine impacts on revenue resulting

If you need to determine impacts on revenue resulting from an increase or decrease in prices and/or sales, the best option to use is a

  Find the decryption function and decipher

Find '(2007), '(2008), and '(b), where b is the integer obtained from the last four digits of your student number.

  How to prepare queries to retrieve the information

How to prepare queries to retrieve the information you need from a database

  Write a short description of odbc, jdbc or java services

Explain what middleware is and what it does. Why would MIS managers be particularly interested in such software?

  Provide a list of threats against the model

I want you to provide a list of threats against the model. The list should include which element of the mnemonic they represent (spoofing, tampering, etc.).

  Activity-based costing approach

Compute the predetermined overhead rate under the current method, and determine the unit product cost of each product for the current year.

  What is normalization and explain why it is important

Write the SQL SELECT statement to display the average rent of the properties. What is normalization? Explain why it is important. List and describe the 4 components of a database system.

  The basic mechanisms for accessing relational database

Describe the basic mechanisms for accessing relational databases from various types of application development environments.

  Identify the functional dependencies

Given the following table, identify the functional dependencies: In the table provided below, fill in the following data such that it is completely un-normalized.  That is, it is not even in 1NF

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd