T he components that would be required to hold time

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

T he components that would be required to hold time-variant data for policy enforcement and training management: The time-variant data is the data that has the multi-value, the previous value, and the current value. Some attributes may have the changed value, such as the email address, phone number, employee address, and other. While there are another attributes must have only one value, such as the birthday date. The time-variant data has the two value, the fist value is the current entity with all the new-value attributes, and the second value has the entity with its
Assignment 4: Database Modeling and Normalization 8 primary key, previous-value data, and the data history. ( Inmon, Bill, 2004), Such as the following example: The Diagram for a possible 1: M solution that will hold salary history data, job history, and training history for each employee:
Assignment 4: Database Modeling and Normalization 9 The step of the normalization process to ensure the 3NF level of normalization using the selected five (5) entities of the personnel database solution: The First Normal Form 1NF is the process of collection all the related columns in one table. Then, it must ensure that no repeated group in the tables. Also, it must implement the primary keys in their locations. Every column has unique value, and must not have the null value. 2NF: "The Second Normal Form 2NF: is the second step of the normalization, and it is built on the First Normal Form 1NF. A 1NF table is in 2NF form if and only if all of its non- prime attributes are functionally dependent on the whole of every candidate key". (Janssen, 2014).
Assignment 4: Database Modeling and Normalization 10 3NF: "Third normal form (3NF) is the third step in normalizing a database and it builds on the first and second normal forms, 1NF and 2NF. 3NF states that all column reference in referenced data that are not dependent on the primary key should be removed. Another way of putting this is that only foreign key columns should be used to reference another table, and no other columns from the parent table should exist in the referenced table". (Janssen, 2014). The diagram at least five (5) possible entities that will be required to sustain a personal solution. The diagram should include the Dependency diagram, and the Multi-valued dependencies:
Assignment 4: Database Modeling and Normalization 11 Second Normal Form:
Assignment 4: Database Modeling and Normalization 12 Third Normal Form: there are no transitive dependencies:
Assignment 4: Database Modeling and Normalization 13 Conclusion: The ERM is the diagram which used to understand the system database by the few steps, The ERM is the diagram used to understand the system database by the few steps with high efficient way, also, it is used to align the company requirements. There are many iterative
Assignment 4: Database Modeling and Normalization 14 steps to draw the Entity Relationship Model ERM for its components: Entities, attributes, relationships, and constraints. If any one of these steps is missed, then the modeling design will

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture