Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hello there, have a look at the complete paper.In case of any concern,feel free to alert me.Regards
Database Modeling and Normalization outline
A. Introduction
B. Determine the steps in the development of an effective ERD
i.
Meeting with the stakeholder
ii.
Meeting with the managers
iii.
With the information from the key stakeholders and the managers, it is possible to
design initial ERDs and models
iv.
Audits of time-variant data
C. Analyze the risks
i.
At times, the applications used may resolve the unintended event leaving the
intended events and hence risking the firm's data.
ii.
The data architect and the end-user of the data may have widely different ideas
about its usefulness
D. Select and rank entities
E. Specify the components that would be required to hold time-variant data
F. Diagram a possible 1: M solution
i.
Diagram
G. Plan each step of the normalization process to ensure the 3NF level of normalization
i.
Normalization to 3NF
H. Diagram at least five (5) possible entities that will be required to sustain a personnel
solution.
i.
Diagrams
I. Conclusion
J. References
Running head: DATABASE MODELING AND NORMALIZATION
Database Modeling and Normalization
Student’s Name
Institutional Affiliation
Date
1
DATABASE MODELING AND NORMALIZATION
2
Introduction
Data normalization is defined as the process of iteration that builds its steps from the
previous ones through the finding of activity requirements and end-user interviews. All databases
are passed through the normalization process during their preparation. Database modelling makes
part of database normalization. It makes it easier to digest the material with the application of
visual models (Hayes, Das, Odom, & Natarajan, 2017). This paper discusses an optimized database
enabling a management staff to carry out the duties of human resource following their abilities to
report the features regarding different departments.
Determine the steps in the development of an effective Entity-Relationship Model
(ERM) Diagram and determine...