Draw an ER diagram for the book store. Specify key attributes and constraints of each entity type and on each relationship type. Note any unspecified requirements and make appropriate assumptions to make the specification complete. 

the diagram will be described using standard ER notation.

Entities:

1. Book

• Attributes: book_id (primary key), title, author, genre, publisher_id (foreign key), publication_date, price
• Constraints: Each book has a unique book_id. A book is associated with only one publisher.

2. Publisher

• Attributes: publisher_id (primary key), name, address, contact_number
• Constraints: Each publisher has a unique publisher_id.

3. PurchaseOrder

• Attributes: _______ ____ ________ __________ ___ _________ __________ _________ _______.
  _____ _________ _______ ________ __________ _________ _______.
  ______ _____ ___ ________ ________ ________.
  ___ ________ ___ _____ ______.
  _________ __________ _____ __________ _________ ______ ____.
  _____ ________ __________ ________ _____ ______ ______ _________ ____ _________ ____ ____.
  _______ ___ ___ ________ _____.
  ______ _______ _______ _________ ________ ____ _____.
  ___ ______ _____ _______ _______ ______ ________ ___ ______ _______ __________.
  __________ ________ _________ ________ ___ _________ ____ ____ ____.
  ________ ____ _________ _______ ________ _________ _____ ___ _______ _________ ___.
  __________ ____ ____ ______ ____ ___ ___ __________ _______ ______.
  __________ _________ __________ ___ ____ __________ _________ _________ _______ _________ __________.
  _______ __________ _________ __________ _______.
  _______ ___ ____ ___ ________ _________ ___ _________ _______ ________.
  __________ ______ _________ ____ _____ __________ __________ _______ ______.
  __________ ________ ______ ___ ___ ______ _____.
  _______ _______ ___ ______ ______.
  ___ _____ ________ _____ __________ _______ ______ ___ _______.
  ________ _________ _________ ________ __________ _____ ______.
  ____ ________ _____ __________ ______ _____ _____ _______ _____ ______ ______.
  ___ ______ ___ _______ ____ ___.
  ____ __________ _______ ________ _________ ___ __________ _______.
  ___ _____ ________ ______ ________.
  ____ ____ _______ ____ ________ _________ ________ _________ ________ ___ ____.
  __________ _______ _____ ____ ________.
  ________ _________ _________ _________ ________ ____ _____ _____ ______.
  ___ ________ _______ ______ ____.
  ____ ____ _________ _______ __________ ________ _________ _____ ______ _____ ___ _________.
  ____ _____ ____ ____ _______ _________.
  _______ _______ ________ _________ __________ ____ __________ ______ ____ _________ ________.
  _______ __________ _________ _________ ___ ____ _________ ____ _________ ____ ______.
  _________ __________ ________ ________ ____ __________.
  ___ _________ ______ ___ _______.
  ______ ________ ___ ___ ________ __________ ____ __________ ____ _____ ___ ________.
  _______ ___ ________ ___ _______ ___ _____ ______ ___ _____ ____ ____.
  _________ ______ ____ _______ _________ ____ _________.
  ___ _____ ________ _______ ________ _________ __________ __________ ___ _______.
  ______ _______ __________ __________ _____ _____.
  _________ _______ __________ _____ _____ __________ _______ ______.
  ____ _________ ________ _____ _______ _______ _________ __________ ____ ________ ____.
  ___ ____ ___ _____ _______ ________.
  Get Full Answer on WhatsApp