This paper focuses on steps to develop an Entity Relational Model (ERM) using a case study of Human Resource Training Management (HRTM) in an organization. It is designed and written to help students learn the process to create a conceptual model by working through the HRTM business activities. ERM represented by Entity Relationship Diagram (ERD), and Chen’s notation being used to illustrate the graphical ERD representation. The following steps which involved are: ((1) Identify, analyze and refine the business rules which involved studying the business activities, gather the information and discover the data elements by identifying the information: needs, users, sources and constitution (2) Identify the main entities (3) Define the relationships among the entities, (4) Complete the initial ERD. Each step is explained and accompanied by examples and diagrams to illustrate the process.
Bodart, F., Patel, A., Sim, M., & Weber, R. (2001). Should optional properties be used in
conceptual modeling? A theory and three empirical tests. Information Systems Research, 12(4), pp.384-405.
Chen, P. (1976). The entity-relationship model -Towards a unified view of data. ACM
Transactions on Database Systems, 1(1).
Codd, E. F. (1970). A relational model of data for large shared data banks. Commun
ACM, 13(6):377–387.
Connolly, T., & Begg, C. (1998). Database systems: A practical approach to design
implementation and management (2nd ed.). Reading, Massachusetts: Addison-Wesley.
Connolly, T. & Begg, C. (2002). Instructor’s guide to database systems: A practical guide
to design, implementation and management. Harlow: England.
Coronel, C. & Morris, S. (2015). Database systems: Design, implementation, and
management (11th Ed.). Cengage Learning.
Hoffer, J.A., Prescott, M.B., & McFadden, F.R. (2002). Modern database management
(6th ed.). Upper Saddle River, New Jersey: Prentice-Hall.
Kimball, R.A. (August, 1997). Dimensional modeling manifesto: Drawing a line between
dimensional modeling and ER modeling techniques,10(9). Retrieved February 10, 2016, from http://www.dbmsmag.com/9708d15.html.
Kroenke, D.M. (2003). Database concepts. Upper Saddle River, New Jersey: Prentice-Hall.
Rob, P. & Coronel, C. (2007). Database systems: Design, implementation, and
management (8th ed.). Boston: Course Technology Ptr.
In-Text Citation: (Amran, Mohamed, & Bahry, 2018)
To Cite this Article: Amran, N., Mohamed, H., & Bahry, F. D. S. (2018). Developing Human Resource Training Management (HRTM) Conceptual Model Using Entity Relationship Diagram (ERD). International Journal of Academic Research in Business and Social Sciences, 8(12), 1444–1459.
Copyright: © 2018 The Author(s)
Published by Human Resource Management Academic Research Society (www.hrmars.com)
This article is published under the Creative Commons Attribution (CC BY 4.0) license. Anyone may reproduce, distribute, translate and create derivative works of this article (for both commercial and non-commercial purposes), subject to full attribution to the original publication and authors. The full terms of this license may be seen at: http://creativecommons.org/licences/by/4.0/legalcode
