Question 2 :- Design a database schema for a bookstore management system. Define tables for books, authors, customers, and orders, including appropriate relationships and constraints. Write SQL queries to retrieve a list of top-selling books and calculate total sales revenue for a given period.