For each relation identify the dependencies: full (no partial); partial; and transitive Create 2NF Solution Create 3NF Solution 1) DesignStaf (ProiectNumber (FK1), bidNumber (FK1), employeeD,_lastName, firstName, role, phone) Functional Dependencies for DesignSta 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 4 digit id assigned to each NBD employee Last name of an NBD employee involved with creation of each design bid First name of an NBD employee involved with creation of each design bid Role of the NBD employee in creation of the design bid. Some times an employee has more than one role in creation of a design bid. Also, the role of an employee in creation of design bid can change from one design bid to another Work phone number of the NBD employee ProjectNumber em DesignStaff lastName firstName role phone