You are undertaking the migration of an application responsible for tracking library books and their details, such as the author or the year of publication, from an on-premises data warehouse to Google BigQuery. In the current relational database setup, the author information is stored in a separate table and is joined with the book information using a common key. According to Google's best practices for schema design, how should you structure the data to ensure the most efficient queries about the author of each borrowed book?