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. 

 

Word Count : 779

---

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) Inventory Table:

• Columns: BookID (Foreign Key), QuantityInStock

2. Relationships:

• The Books table is related to the Publishers table through the PublisherID column. This relationship represents the publisher of each book.
• The PurchaseOrders table is related to _____ ___ __________ ________ ___________ _________ ________ ____ ______ _________ ________ __________.
  ____________ ______ ____ _______ _______ _____ ____ _____________ ___ ________ ___ ___.
  ____________ ____ _________ _____ ____ __________ _______ __.
  ______ __________ _____________ ________ ________ ___________ ____ _____________ __________ __________ ____ ___________ ___________.
  ____ __ _____ ________ ____________ __________ _________ ______ _______ ______.
  _________ __________ ______ ____ ________ ___________ ____ ____ __ ____________ ______ ____.
  __________ ______ ____________ __ _____________ __________ ___________ ___________ ___________ ___ _______ _____________ ____.
  ____ ______ ___________ _____________ __ ____ _______ ________.
  __ ________ _____________ __ _____________ __ ___ ___ _______ ______.
  _______ ______ ____ ____________ ______ _____________ ______ ___________ ___________ _____.
  _____ _________ _______ __ ___________ ___ __ _______ ___________ __ _____________ ____ _____ ____________.
  _____ ___________ ______ ____________ _____________ ___________ _______ ___ ______ ___ ___________ __________ ________.
  ___________ ______ ___ _____________ __________ _________ _________ _________ ___ _______ ____ _____ __.
  ___ ___ _____________ ___ ___________ _____________.
  ___ _____ _____ ________ ____ ____ ____________ _____________ _______ _____ _______ __________ ___.
  _____________ __________ ________ _____________ ________ _____ _______ _________ _______ _____ __ _________ _________ _____.
  __ _________ ___ _________ __ __ ___ __ ___________ __ __ __ _____.
  ________ ___________ _____________ _________ ____________ _____ ______.
  _________ ______ ___ _________ ___________ _____.
  ____________ ____________ ___ __ _________ ___________ ____________ ____.
  __________ __ _________ ______ ___ _________ ________ __ ______ ________.
  _________ _____ ____ ____________ ____________ _____________ _______ ___ _____________ _____________ _______.
  _____ __________ __________ _________ ____________ _______ _______ _______ ___ __ ____.
  ____ _____ _________ ___________ _______ __ ___________ _______ __________.
  __________ ________ _________ _________ _______ __.
  ____ ________ _____ ________ ________ _____________ __.
  _____________ _______ ___________ ________ ____ __________.
  ________ _______ _____________ ____________ ___ _____ _____________ _____________ ____ ____ _____________ _______.
  ___________ _____________ ___________ ________ __ ______ _______.
  ______ ___________ ____ ____________ ______ _______ _________ ____________ __ ______ _______ ______ ____________.
  _________ _________ ____________ ___ ____ ____ _______ _____________ __.
  ________ __________ _____________ __________ ________ __ ____ _____________ _______ ___________.
  ________ __ _____________ __ ____ _________ _______.
  ________ ___ ____________ ____________ __________ ____ ____________ _______ ____.
  _____ _____ ____________ ___ __________ ______ _____________ ___ ________ ______ ______ ______ ____ ______.
  ___________ ____ __ _______ _____ ______.
  _____ __________ ______ __ __ __.
  _______ __________ ____________ _______ __ ____ _____________ _________ ____ __ ______ ____ _______ ___________.
  ____________ _________ _______ _______ _____ __ __________ _______ ______ _______ _________.
  _____________ ___ __________ ____________ ___________ _______ ___ __ _________ ____________ ________ ____ __________ ________.
  ____________ ______ ________ __ _________ _____ ________ ____________ ________ ____.
  __________ _________ ____________ _____ ____________ _____.
  __ _____________ ___________ _________ ___ __ _________ __________ __.
  ____ _____ ___ __ _____ __ _____________ ___ _____________ _____.
  ________ ____ __ _________ ______ __ ___ ____ ______ ___ __________.
  _____________ ____ __________ __ _____________ _________ _______ ___.
  ______ _______ _________ _______ ________ __ _______ _________ ___________.
  ________ ___________ _________ _________ __ _____ ____________ ____.
  ____ _____ _________ _______ __________ _______ _______ _____________ _____ ___ _____________ ________ ____________ _________.
  _______ ____________ __ __________ __ _________ ______ ____ __ ________.
  ____________ ___________ ____________ ____________ ___ ________ ______ ____ _________ __________ ____.
  _____ _______ _____________ ___________ __ ___________ _________ _______ ___________.
  __ _______ _______ _______ ____________ ___________ ______ _______ ________ ___ ____.
  _____________ _______ _________ ______ _____ ________.
  _____________ __________ _____ _________ _____________ _______ ____________ _____________ _________ ___ _______ ___ _________ ________ ___.
  __ _________ ____________ _____ ____ _________ ____________ _________ _______ ___________ __ __________ ____________ ___________ ______.
  ____________ __ _____________ __ _________ ___ ___.
  _______ _______ _____________ __ ____ _____.
  ________ _____________ _____ ________ ___ ______ _________ ____________.
  _________ ___________ ____ _____________ ________ ________ __________ ___________ ____ ___________ _____________ ___________ __________ __________.
  _______ ________ _____ _____________ ___ __________.
  ______ __ _________ ______ ____ ___ _____________ _____ _________ ______ ___ _________ ________ _____.
  Click Here to Order Full Assignment on WhatsApp
  

Degree : PG DIPLOMA PROGRAMMES
Course Name : POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS
Course Code : PGDCA_NEW
Subject Name : Database Management Systems
Subject Code : MCS 207
Year : 2022 2023