3) (FK1), bi FK1 Functional Dependencies for Bi No Partial Dependencies: Partial Dependencies Transitive Dependencies: 2NF Solution 3NF Solution Table Name Attributes Explanation of attribute Remarks A unique 8 digit identification that is assigned to each project for all tracking all business transactions and activities Since a project may have multiple revisions for design bids, each design bid is assigned a version number in sequence For example 01, 02, 03, A unique code of up to 4 digits and letters, assigned to different broad categories of work done on projects Common description of the work for the laborCode The estimated number of hours included in the bid version, for labor description associated with LaborCode The unit price quoted for the labor included in the design bid. Depending on season, number of hours required, the relationship with the client-the unit price quoted can change from one design bid to another Pr LaborDesc hours laborUnitPrice 3) (FK1), bi FK1 Functional Dependencies for Bi No Partial Dependencies: Partial Dependencies Transitive Dependencies: 2NF Solution 3NF Solution Table Name Attributes Explanation of attribute Remarks A unique 8 digit identification that is assigned to each project for all tracking all business transactions and activities Since a project may have multiple revisions for design bids, each design bid is assigned a version number in sequence For example 01, 02, 03, A unique code of up to 4 digits and letters, assigned to different broad categories of work done on projects Common description of the work for the laborCode The estimated number of hours included in the bid version, for labor description associated with LaborCode The unit price quoted for the labor included in the design bid. Depending on season, number of hours required, the relationship with the client-the unit price quoted can change from one design bid to another Pr LaborDesc hours laborUnitPrice