Relational Database Model Example

Relational Database Model Example Relational Database Model – Coursework Example Relational Database Model Insert Insert Introduction A business function relates to operations that run in an organization on a daily basis. They are innate in the entire mission that drives the firm (Inmon, ONeil & Fryman, 2008). The rules in the business are in place to control and define the framework of the functions that run in this institution. The firm mainly handles employees who register daily to work in the business and receive their wages at the end of the day. The company tracks the employee, the number of hours they have worked and use that to ascertain how much to pay the employee. Based on this information, the firm has three entities namely employee, wages and job.Figure 1: Entity Relationship DiagramThe key fields for the entities in the database include employee_id, wages_id, and job_id. The fields are unique thus all the other attributes in the tables are dependent on them. They do not allow null or duplicate values.The relationships in the entities show a one-to-m any relationship between employee and job entities. There is also a one-to-many relationship between employee and wages table. Further, there is a one-to-one relationship between the wages and job table. The latter is true because one job can only have one payment specified for it. On the other hand, one employee can have many jobs and consequently have many wages.The business rules in the organization clearly state that an employee can only be given another job after completing the previous one. The above rule only applies to employees whose consistency last more than one year at the firm (Halpin & Morgan, 2008). The relationship may change when a firm decides that there will be only one job for one employee. The cause may be an increase in the population of workers and urgency to complete the duties within the stipulated time.ReferencesHalpin, T., & Morgan, T. (2008). Information modeling and relational databases. Burlington, MA: Morgan Kaufmann Publishers.Inmon, W., ONeil, B., & Fryman, L. (2008). Business metadata. Amsterdam: Elsevier/Morgan Kaufmann.