Reference no: EM131322062
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 page paper in which you:
1. 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.
2. Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are not performed.
3. Select and rank at least five entities that would be required for the development of the data repositories.
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. 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 entities of the personnel database solution. Document each step of the process and justify your assumptions in the process.
7. Diagram at least five possible entities that will be required to sustain a personnel solution. The diagram should include the following:
1. Dependency diagrams
2. 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.
Expectations of a group social norm
: Deviant behavior violates standards and expectations of a group social norm. Reflect on a time when you violated a widely shared and understood norm of your society. What was the norm? What was the violation? What sanctions did your social group p..
|
Importance of self-motivation as a strayer university
: Review the short Strayer University video in Instructor Insights. Briefly provide your about the importance of self-motivation as a Strayer University student.
|
How much physical memory is needed for storing page table
: For a single-level page table, how many page table entries (PTEs) are needed? How much physical memory is needed for storing the page table?
|
Factors involved in food production by hominids
: Discuss the factors involved in food production by hominids. Include information relating to settled agriculture, domestication of vegetative and animal forms, and pastoralism.
|
Determine steps in development of an effective erm diagram
: Determine the steps in development of an effective ERM Diagram and determine possible iterative steps / factors that one must consider in this process with consideration of HR core functions and responsibilities of the client.
|
Drag the planet to the inner boundary of the chz
: Drag the planet to the inner boundary of the CHZ and note this distance from the Sun. Then drag it to the outer boundary and note this value. Lastly, take the difference of these two figures to calculate the "width" of the sun's primordial CHZ
|
Discuss about the gay liberation front
: The Stonewall riot was a turning point for gay and lesbian Americans. In June 1979, police raided the Stonewall Bar in New York. The raid itself was not an uncommon occurrence, but when gay patrons fought back, the incident became a rallying point..
|
Couple options for living environments
: Demographics, beliefs, finances, independence, and many other factors may affect an individual's or a couple's options for living environments.
|
How many ptes are needed to store the page table
: Assuming a hash table implementation, what are the common case and worst case numbers of memory references needed for servicing a TLB miss?
|