As you migrate an application from an on-premises data warehouse to BigQuery, which manages information about library books and their associated details like author and publication year, you encounter a schema design challenge. In your current setup, author information resides in a separate table, linked to book details through a common key. Following Google's recommended practices for schema design, how should you structure the data to ensure optimal query performance for retrieving information about book authors in a borrowed scenario?