4. Given a table PROJECT as follows Hours projectlD Name task Payrate extension taskID projectLoc projectManager In task John a 30 150 John b 10 150 Roman a 30 120 Shaw a 30 120 Shaw b 10 120 Shaw c 20 120 Peter a 15 1402 1 NY Lee 5 1 LA 6 2 LA 1 1NY 1 1 NY 2 2NY 2 3 NY Smith Kim Smith Smith Smith smith a) make the table in the format: table_name (attribute1, attribute2,...) b) List all functional dependencies (FDs) c) define the key for this table based on given data. d) state the normal form this table is currently in, WHY? e) How do you normalize it? Show the tables after normalization. Show Keys and FKs