This is a database suitable for an online bookshop with namely 7 tables.
BookInfo ---- has all details of the books(those may/may not be present in store)
Inventory ----- has details of books present in store with coressponding quantity,price and suppliers
Supplier ----- has the list of suppliers
Purchase ------- has the entry of all purchases made in the shop
Customer -------- stores the contact and name of customer
Autdet ------- Contains details of Author including age,name,sex(the details are randomly genrated using a python script and real world authenticity is not present)
log_pu_details ------contains the log of books which were purchased and by whom etc and it also contains details of any ordes if it was cancelled.
triggeres and certain complex queries are mentioned in triggeres and query file.