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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!