Project management system and normalization process
computer science
Description
Consider a project management system in which each employee is assigned to a specific department and employees from several departments often are assigned to special project teams, however, when a new product is launched or for major marketing events. Note that the project hours are the number of hours that employees charge to their assigned projects. The following is an example of an un-normalized PROJECT-DATA table for two projects. Perform the normalization process to convert the above un-normalized table to: 1. First normal form (1NF) 2. Second normal form (2NF) 3. Third normal form (3NF)
