If any one of these steps is missed then the modeling

This preview shows page 14 - 15 out of 15 pages.

relationships, and constraints. If any one of these steps is missed, then the modeling design will not implement the system requirements, the many risks must to be faced, also, the database model may be fail. There are various effective entities in the government companies, that is required for the development of the data repositories such as: management, department, employee, salary, and the customer entity. There is another type of data has multi-value because of its changed value such as the email address, phone number, etc. this data is called the time- variant data; therefore, it must store the history of the data by the date stamp, to retrieve it when we need that. In all these types of data may be there are the redundancy; therefore we need the process to eliminate this redundancy. This process is called the Normalization: Which has the various forms: 1NF, 2NF, and 3NF, and every form has its steps. In my paper, I explained all these steps with details. References: infocom.cqu.edu.au, (2006 ), Developing Entity Relationship Diagrams (ERDs) (pdf), Retrieved from McDonald, Caroline, (2004), Article of (ERM Success Checklist), National Underwriter / P&C (Journal), Retrieved from - cfdd-45e0-8a48-63c08dfa7d87%40sessionmgr4004&vid=4&hid=4111
Assignment 4: Database Modeling and Normalization 15 Carlos Coronel, et al., (2013), Article of (Data Model Basic Building Blocks), Database Systems: Design, Implementation, and Management, 10e, 10th Edition. Caroline Gilbert, (2011), Article of (The influence of line managers and HR department on employees’ affective commitment), The International Journal of Human Resource Management, Vol. 22, No. 8, April 2011, 1618–1637, Retrieved from - 9f85f105aa7f%40sessionmgr110&vid=7&hid=103 Inmon, Bill, (2004), Article of (Measuring Time in the data Warehouse), DM Review. Oct2004, Vol. 14 Issue 10, p64-65. 2p. (Journal), Retrieved from - fa0120477ccc%40sessionmgr115&vid=7&hid=103 Janssen, C. (2014 ), Definition - What does First Normal Form (1NF) mean?, Retrieved from Janssen, C. (2014), Definition - What does Second Normal Form (2NF) mean?, Retrieved from Janssen, C. (2014), Definition - What does Third Normal Form (3NF) mean?, Retrieved from Professional Visio 2013.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture