Here is a table in 1NF:

1NF(projNum, projName, empId, empName, jobClass, chargePerHour, assignedHours)

It is in 1NF because:

All attributes are single-value attributes in a given tuple (row)

However it is NOT in 2NF

Assumptions:

Every project has a unique project name

Employees can work in any number of projects

Each employee has a unique job class (e.g., electrician, plumber,)

Each job class has a unique charge per hour

We want to track how many hours is assigned to each project

Each employee has a unique employee ID

Part 1)

What are the functional dependencies for the above table?

Part 2)

Create two or more 2NF tables for this table.

Part 3)

Create two or more 3NF tables for this table