DATABASE MODELING AND NORMALIZATION 2 Introduction Organizations today especially business ones store large quantities of data records as computer based files in databases. A database can be described as a structured collection of records that is stored in a computer system. Databases are critical assets of any business organization since they can be leveraged as a competitive edge through data mining and data warehousing concepts (Vesely, 2010). My organization is in the business of offering information technology and database services including optimization and streamlining solutions for efficiency. Systems such that the management team will be able to perform various human resource duties and as well be capable of producing ad hoc reporting features for other departments. The new system should also be able to enable the agency to perform other human resources functions including policy enforcement, hiring, promotions, and training. STEPS IN ERM An Entity Relationship Model (ERM) diagram is utilized to illustrate the flow of information as it is reviewed by the end user. The data represented in an ERD diagram include business entities, their attributes, as well as the relationships among those entities. ERM diagrams are represented by fours symbols which include rectangles of the entities (Lightstone, 2011). The iterative steps that will be involved in the creation of ERD diagrams for the government agency is as described below: oThe first step involves establishing the entities of the ERM diagram which includes Project, Employee, Manager, Trainee, and so on. oThe second step involves establishing the attributes of the entities; an example is EmployeeID which is an attribute of the Employee entity.
