Q$1.$ Using phpMyAdmin in xampp, create a simple database schema for a bookstore management system. This database will include tables for storing information about books, authors, publishers, and customers. Here's the schema specifications:

Books Table:

book$\_$id: INT $($Primary Key$)$

title: VARCHAR

author$\_$id: INT

publisher$\_$id: INT

genre: V$$RCHAR

publication year: YEAR

price: DECIMAL

quantity$\_$available: INT

Authors Table:

author$\_$id: INT $($Primary Key$)$

author$\_$name: VARCHAR

Publishers Table:

publisher$\_$id: INT $($Primary Key$)$

publisher$\_$name: VARCHAR

location: V$$RCHAR

Customers Table:

customer$\_$id: INT $($Primary Key$)$

customer$\_$name: VARCHAR

email: VARCHAR

phone$\_$number: VARCHAR

address: VARCHAR

Orders Table:

order$\_$id: INT $($Primary Key$)$

customer$\_$id: INT

order$\_$date: DATE

total$\_$amount: DECIMAL

Insert $3$ tuples$($rows$)$ in each tabe please solve