A Book Store needs to maintain a database system for maintaining the information about the books. The database is needed for the following requirements:
 To find the available books in the store along with the name of publisher, date of publishing and price of the book.
 To find the information about various publishers of the Books, from whom the books can be procured directly.
 To find the information of various purchase orders of books from various publishers. Please note that one purchase order may include list of various books and their copies being ordered.
 To keep track of current stock of books, book sale, reordering of books etc. 

To meet the requirements of the Book Store, a comprehensive database system can be designed to efficiently store and manage the information about books, publishers, purchase orders, and inventory. The database system can be structured using multiple tables to organize the data and establish relationships between different entities. Here's a suggested design for the database system:

1. Tables:

a) Books Table:

• Columns: BookID (Primary Key), Title, PublisherID (Foreign Key), PublishDate, Price

b) Publishers Table:

• Columns: PublisherID (Primary Key), PublisherName, Address, Contact

c) PurchaseOrders Table:

• Columns: OrderID (Primary Key), OrderDate, PublisherID (Foreign Key), TotalAmount

d) BooksInOrder Table:

• Columns: OrderID (Foreign Key), BookID (Foreign Key), Quantity

e) _______ ______ ________ __________ ____ ______ ____ ________ ______ __________ ___.
_________ ____ _______ _________ ___ _____ ______ _____ _____ _______ ____ _____.
_____ _______ _____ __________ ____.
_______ ___ _______ ___ ____ _________ ____ _____ ______ ______ ________.
_________ _______ ____ _____ ___ __________ _____ ________ ________ __________ ________.
___ _____ _________ ________ _________ _____ __________.
__________ _______ __________ ______ ___ ______ ____.
______ ________ _______ ____ _________ _____.
____ _____ ___ _______ ______.
___ ___ ____ _______ __________ _________ _________ ______ _____.
___ __________ __________ _____ _____ __________ ________ ______ ______ ______ ________ _____.
___ ____ _________ ______ ______ _______ _______ _________ ____ ___.
_____ ___ ____ ______ _________ _____ ______.
________ ______ ____ ______ __________ ____ _____ _______ ___ _________ ______.
_________ __________ ____ ______ _______ _________ ________ __________ __________ ___ _____.
_____ __________ ____ _________ ____ ___.
________ ___ ____ ______ ________ ____ ______ ________ ______ ______ ___ __________.
_____ _______ ___ _____ ________ _________ __________ ______ _________.
_________ ____ _________ __________ ___ _______.
_____ _____ ________ ______ ______ _________ ___ _____ _____ _____ ________.
___ _____ __________ ___ _________.
_____ ____ ______ ___ __________ ____ ___ _________.
___ ___ ___ ___ ____ ________ _________ __________ _______ _______.
__________ _____ ___ ____ ____ ________ ___ ________ ____ ___ _______ _______.
________ ____ _____ _______ __________.
_________ __________ _________ ______ _______ _______ ____ _______ __________ __________ _______ ____.
________ ________ ______ ___ ____.
____ _________ ______ _______ ___ ______ ______ __________.
__________ __________ __________ ___ __________ _______.
____ ____ ________ ___ ___ _______ ___ __________ __________ _________ ________.
__________ ______ _________ __________ ______ ________ __________ ___.
__________ ______ ___ ____ __________ ____ _____ ______ _____.
____ ______ _________ ___ ____ ____ _____.
_________ ______ __________ _______ _______ __________ ____ _____ ________ ___ ___ _____.
_______ __________ _________ _____ _____ ____.
______ _________ ____ _______ ____.
_______ _______ ____ ________ _____ ____ ___.
_______ ______ ____ _____ ______ _____.
__________ _________ ____ _____ _________ _________ __________ ________.
___ ____ _______ _______ ____ __________ ________.
_______ ____ _______ ___ ____.
__________ ____ __________ _____ ___ ________ _____ ____.
______ ________ _____ __________ ___ ____ _________ ________ ____ ______.
______ _________ __________ ________ _________ ___ ___ ______ _______ ______.
__________ ______ __________ ________ ________ __________ _________ _____ ________.
_______ ____ ____ ______ ____ _________ _________ ______.
___ ________ _______ ________ ____ ____ __________ ______ _________.
_______ ______ __________ _______ ____ _________ ____.
______ ______ ________ ______ _____ ______ _____ _____ ________ _________ _________.
______ ______ ___ ____ __________ __________ ____ __________ ____.
_________ ___ _____ ____ _______ __________ ________.
___ ____ __________ ________ _________ ____ ___.
__________ _________ _____ ______ _____.
___ __________ _____ ________ ________ _____.
_________ ______ __________ ___ ______.
________ _________ _________ ___ ___ _____ ______ _____ _______ ______ ________.
________ __________ _______ ___ _________ _______ _________.
___ __________ _______ ____ _____ _____ _________ ________ ____ ________ ___ ________.
___ __________ _____ ____ _______ _________ _____ ___ _____ __________ _______.
______ ________ _____ ______ ____ __________.
______ _________ ________ ________ _____ _______ ________ _____.
___ ___ _____ ____ __________.
____ ___ __________ __________ __________ _______ ______ ___ ________ _________.
_____ _________ __________ __________ _________ ____ _____ __________ __________ ________.
___ ____ ________ _____ ____ __________ ___ ______ __________.
__________ _______ _______ ________ ___ _____ __________ ______ _______ __________ ________ _______.
_______ __________ ______ _________ __________ ______ __________.
__________ ________ _________ _____ _____ ______ ________.
___ _______ _______ ___ _________.
Get Full Answer on WhatsApp