Database Modeling and Normalization Research Paper

Open, View, and/or
Download this Document

Total Length: 940 words ( 3 double-spaced pages)

Total Sources: 2

Page 1 of 3

Database Modeling and Normalization

Entity Relationship Model (ERM) Diagram is a data model used to describe the database in an abstract method. The relational database stores data in table. The entity in the database could point to several entries. For example, employee is an entity in the relationship database, and a diagram used to create the entity in the database is called entity-relationship diagrams or ER diagrams. (Silberschatz, Korth, 2006).

Objective of this report is to develop an entity relationship diagram for a consulting firm that offers information technology and database services. The firm attempts to create a relationships database to optimize and offer streamline solution efficiently in order to satisfy the government's requirements. The firm will create an ERM database to optimized data repository that will allow the firm to perform human resources (HR) functions effectively, which include as policy enforcement, benefits management, hiring, promotions, and training.

The paper provides the steps to employ to develop an effective Entity Relationship Model (ERM) Diagram for the firm.

1.1: Steps to Develop of an effective (ERM) Diagram

Steps in the development of ERM diagram for the HR core functions and responsibilities of the clients are as follows:

Entities: Identification of entities that will be should be used to develop HR core functions and responsibilities of the client.

Relationships: The next step is to develop relationships among the entities. For example, there is a relationship between HR employee and training, benefit management, policy enforcement, promotion, and training because HR employees will offer these services to employee of different departments within the organization Database.

Stuck Writing Your "Database Modeling and Normalization" Research Paper?

View All Our Example Database Modeling and Normalization Research Paper

Have A Custom Example Essay Written

( Rob, & Corone, 2009).

Attributes: The next step is the identification of attributes. A data attribute is a characteristic that is common to all instances of a particular entity. The attribute in the database for the firm's ERD are as follows:

Attribute of Entity Employee are Name, address, Phone Number Employee Number, pay rate,

Attribute of Hiring are computer appreciation, Quantitative analysis

The next step is to draw the Entity Relationships Diagram that reveals all the entities, attributes and their relationships. The final step is to test the database.

The possible iterative steps to consider in the consideration of HR core functions and responsibilities of the clients is to develop employment policy which involves determining qualification, assigning positions, job descriptions, salary, wages, benefits and legal compliance.

The HR core functions to be considered in the database development for the firm include:

Hiring process

Screening,

Application handling,

Performance management and payroll,

Promotion and Raises

Employee service process.

1.2: Analysis of the Risks

In the development of database, all the developmental steps must complete to enhance effective functioning of database. A complete development of all the steps in the database will assist the firm to achieve the data reliability which will enhance confidence in the data values. However, there are….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Database Modeling And Normalization" (2013, July 27) Retrieved May 17, 2024, from
https://www.aceyourpaper.com/essays/database-modeling-normalization-93528

Latest MLA Format (8th edition)

Copy Reference
"Database Modeling And Normalization" 27 July 2013. Web.17 May. 2024. <
https://www.aceyourpaper.com/essays/database-modeling-normalization-93528>

Latest Chicago Format (16th edition)

Copy Reference
"Database Modeling And Normalization", 27 July 2013, Accessed.17 May. 2024,
https://www.aceyourpaper.com/essays/database-modeling-normalization-93528
   

Open, View, and/or
Download this Document
order custom essay example