The ERD listed below depicts a book store. An ORDER can have many books on it and a book can be on many ORDERs. Additionally there can be many Authors per book and an Author can write many books. How would you revise this draft?

$\backslash$table$[[$ORDER$],[$OrderID: VARCHAR $[$PK$]],[$OrderDate: VARCHAR$],[$CustomerID: VARCHAR$],[$Employeeid: VARCHAR$]]$

$\backslash$table$[[$BOOK$],[$BookID: VARCHAR $[$PK $]],[$Title: VARCHAR$],[$AuthorID: VARCHAR$],[$CopyrightDate: VARCHAR$],[$ISBN: VARCHAR$]]$

Take the OrderID in ORDER and place it in BOOK. Create an entity for AUTHOR and place BookID in AUTHOR as a foreign key.

Nothing needs to be done. This is perfect.

Take the BookID in BOOK and place it in ORDER. Create an entity for AUTHOR.

Create a linking table between ORDER and BOOK. Additionally create an entity for AUTHOR and linking table between AUTHOR and BOOK.