You are given a following schema in 1NF: (First, Last, Address, Job, Salary, Assistant) , the parimary keys are first, last and job.

The following set of functional dependencies

: First, Last ->Address

Job -> Salary, Assistant

The data:

John, Smith, 111 N. Wabash Avenue, plumber, 40K, NULL

John, Smith, 111 N. Wabash Avenue, bouncer, 35K, NULL

Jane, Doe, 243 S. Wabash Avenue, waitress, 52K, NULL

Jane, Doe, 243 S. Wabash Avenue, accountant, 42K, Yes

Jane, Doe, 243 S. Wabash Avenue, bouncer, 35K, NULL

Mike, Jackson, 1 Michigan Avenue, accountant, 42K, Yes

Mike, Jackson, 1 Michigan Avenue, plumber, 40K, NULL

Mary, Who, 20 S. Michigan Avenue, accountant, 42K, Yes

Mary, Who, 20 S. Michigan Avenue, risk analyst, 80K, Yes

Decompose the schema to make sure it is in Third Normal Form (3NF).