Question: 3. Given a table PROJECT as follows projectIDName task salary lextension Hours tasklD projectName projectLocprojectManager In task ohn 2 150 LA lee ohn b 30

3. Given a table PROJECT as follows projectIDName task salary lextension Hours tasklD projectName projectLocprojectManager In task ohn 2 150 LA lee ohn b 30 150 LA smith Romana 10 120 bc NY kim Shaw 10 120 NY smith haw b 10 120 NY smith Shaw 11 120 NY smith Peter 15 140 NY smith 3a. make the table in the format: table_name (attribute1, attribute2,...) 3b. List all functional dependencies (FDs) based on given data 3c. Define the key (and candidate key if there is any) for this table based on given data 3d. state the normal form this table is currently in 3e. How do you normalize it? Show tables after normalization. Indicate key and FKs
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
