5. Suppose we have the schema book(accessionno, isbn, title, author, publisher, userid, username, userdeptid, deptname) and the dependencies: Type Dependency accessionno isbn isbn title, publisher isbn author userid username, userdeptid userdeptid deptname a. Identify a correct primary key for the table using the relational schema notation (i.e., bold and underline) given the dependencies above. book(accessionno, isbn, title, author, publisher, userid, username, userdeptid, deptname) b. Identify each dependency as functional, full, partial, transitive, or multivalued. Place your answer in the table above. c. Are there any other dependencies that can be determined based on the dependencies listed? List any you discover and label them with a type. Add more rows if needed. Dependency Type d. Convert the table R into BCNF using the dependencies listed above. Write the solution using our relational schema notation from the lectures. You can label tables with numbers, for example, R1, R2, R3, etc