Table: Author Author_ID DZN9010 VC8931 STA7686 Author_Name J.K. Rowling Arthur Conan Doyle Suzanne Collins a. ii, iii b.

[answerhappygod]

Table Author Author Id Dzn9010 Vc8931 Sta7686 Author Name J K Rowling Arthur Conan Doyle Suzanne Collins A Ii Iii B 1 (55.52 KiB) Viewed 34 times

Table: Author Author_ID DZN9010 VC8931 STA7686 Author_Name J.K. Rowling Arthur Conan Doyle Suzanne Collins a. ii, iii b. ii, iii, iv c. i, ii, iv d. il only Book Title Harry Potter Sherlock Holmes Hunger Games Author_Origin England Scotland USA How can we remove the transitive dependencies from the table above? i. Create a separate Name table with Author_ID as primary key ii. Create a separate Book table with Book_ID as primary key iii. Create a separate Origin table with Origin_ID as primary key Create a Book_ID and make it a foreign key in Author table iv.