Can I read Normalization Activity: Employee Data on EtoBox?

Normalization Activity: Employee Data by Timotheo bustamante is a document available to read on EtoBox.

What is Normalization Activity: Employee Data about?

1. The document describes normalization of employee work data from 1NF to 3NF. It includes the schemas and key information for each normal form. 2. In 1NF, employee ID is the primary key and there are partial dependencies between other attributes. In 2NF, data is split into Employee, Company, and Work tables to remove partial dependencies. 3. In 3NF, Company Name becomes its own table with a foreign key to Company Code to remove transitive dependency. Primary keys are underlined and relationships shown

Author

Timotheo bustamante

Language

EN