96%(52)50 out of 52 people found this document helpful
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 willnot implement the system requirements, the many risks must to be faced, also, the databasemodel may be fail. There are various effective entities in the government companies, that isrequired 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 becauseof 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 whenwe need that. In all these types of data may be there are the redundancy; therefore we need theprocess to eliminate this redundancy. This process is called the Normalization: Which has thevarious forms: 1NF, 2NF, and 3NF, and every form has its steps. In my paper, I explained allthese steps with details.References:infocom.cqu.edu.au, (2006), Developing Entity Relationship Diagrams (ERDs) (pdf), Retrievedfrom 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 15Carlos Coronel, et al., (2013),Article of (Data Model Basic Building Blocks), DatabaseSystems: Design, Implementation, and Management, 10e, 10th Edition.Caroline Gilbert, (2011), Article of (The influence of line managers and HR department onemployees’ affective commitment), The International Journal of Human Resource Management,Vol.22,No.8,April2011,1618–1637,Retrievedfrom-9f85f105aa7f%40sessionmgr110&vid=7&hid=103Inmon, Bill, (2004),Article of (Measuring Time in the data Warehouse), DM Review. Oct2004,Vol.14Issue10,p64-65.2p.(Journal),Retrievedfrom-fa0120477ccc%40sessionmgr115&vid=7&hid=103Janssen, C. (2014), Definition - What does First Normal Form (1NF) mean?, Retrieved fromJanssen, C. (2014),Definition - What does Second Normal Form (2NF) mean?, Retrieved fromJanssen, C. (2014),Definition - What does Third Normal Form (3NF) mean?, Retrieved from Professional Visio 2013.