96%(53)51 out of 53 people found this document helpful
This preview shows page 7 - 15 out of 15 pages.
The components that would be required to hold time-variant data for policy enforcementand training management:The time-variant data is the data that has the multi-value, the previous value, and thecurrent value. Some attributes may have the changed value, such as the email address, phonenumber, employee address, and other. While there are another attributes must have only onevalue, such as the birthday date. The time-variant data has the two value, the fist value is thecurrent entity with all the new-value attributes, and the second value has the entity with its
Assignment 4: Database Modeling and Normalization 8primary key, previous-value data, and the data history. (Inmon, Bill, 2004),Such as thefollowing example:The Diagram for a possible 1: M solution that will hold salary history data, job history, andtraining history for each employee:
Assignment 4: Database Modeling and Normalization 9The step of the normalization process to ensure the 3NF level of normalization using theselected five (5) entities of the personnel database solution:The First Normal Form 1NF is the process of collection all the related columns in onetable. Then, it must ensure that no repeated group in the tables. Also, it must implement theprimary keys in their locations. Every column has unique value, and must not have the nullvalue. 2NF: "The Second Normal Form 2NF: is the second step of the normalization, and it isbuilt 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 103NF: "Third normal form (3NF) is the third step in normalizing a database and it buildson the first and second normal forms, 1NF and 2NF. 3NF states that all column reference inreferenced data that are not dependent on the primary key should be removed. Another way ofputting this is that only foreign key columns should be used to reference another table, and noother 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 personalsolution. The diagram should include the Dependency diagram, and the Multi-valueddependencies:
Assignment 4: Database Modeling and Normalization 11Second Normal Form:
Assignment 4: Database Modeling and Normalization 12Third Normal Form:there are no transitive dependencies:
Assignment 4: Database Modeling and Normalization 13Conclusion:The ERM is the diagram which used to understand the system database by the fewsteps, The ERM is the diagram used to understand the system database by the few steps withhigh efficient way, also, it is used to align the company requirements. There are many iterative
Assignment 4: Database Modeling and Normalization 14steps 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