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. 

Word Count : 518

---

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: order_id (primary key), publisher_id (foreign key), order_date, total_amount
• Constraints: Each purchase order has a unique order_id. A purchase ______ __________ _____________ ______ __ ___ ____ ___________ ______ _________ ___________.
  _____________ ________ ____________ _________ _____ _______ _____ _____________ _____________ _______ ____ _______.
  ________ ___________ ___________ _____________ ____ ____________ _____ ___________ ________ __________ _____________ ___________.
  _____________ _____________ __________ __ _______ _______ ____ ____________ ___ ________ ____________.
  _________ _________ _____ ________ _______ _____________ _____________ ____ ___________ ___________ ___ ____.
  __________ ____________ __ ____________ ___ _____________ __ ____________ _______ ____________ _______ __ _______.
  _______ _____ ___________ _____________ ____________ __ _________ ___ _________.
  ____________ ________ _____________ _______ _______ _______.
  _______ ________ _______ ___________ ______ _________ ___ ________ _____________.
  _____ ___________ __________ __ _______ ___ ___.
  ____ _____ ____________ ___________ __ ___ __________ ___ ____________ ____________ ___ __________ ____.
  ________ _____________ ____________ __ ____________ __________ ______ __________ _______ _____________ ________ _______.
  ___ __ _____ _____ ______ _________.
  ____ ____ ______ __ __________ ______ _______ _____ ____.
  _____ ____________ _________ ___ ___________ __________ ____ _____ _____ _____________.
  __________ __ __ _____________ _____________ _____.
  _____________ ____ _______ ___ __________ ______ ______ __ ____.
  ____ _____________ ________ ______ __________ ____ ______ _______ ___ __ ____ ________ _____________ ___.
  _______ ________ __ ________ ___________ ____ ____________ _________ ___ ____ _________ ____________ ___________ _____ _________.
  _____________ ____________ ______ ____ __ _____________ ______ ________ _______ __ ___________ ____________.
  _______ __________ ____________ _______ _____________ __________.
  ___ _____________ _____________ ___________ _____________ _________ ___ __.
  _______ __ ___ ________ __ ____ ______ ___________ ___________ _______ _______ ____ __.
  ____________ ______ __________ ____ _________ ________ _________ __________ ___________ ___ ____________ __________.
  __ _________ _____________ ___ ________ _________ ____________ _______ ______ ____ ______ _______.
  _______ _______ _______ ___ ________ _____ _____________.
  _____ _______ ___________ ________ __ ______ __________.
  _____ ________ ___________ ___ _____________ _________ ___________ ___________ ____ _______ _________ ________.
  __________ ______ _____ ______ __ _____ ___ __ _____________ _______.
  _______ _______ __________ _______ ________ _____ _________ _______ _____ ___.
  ________ ___________ _______ _____ _________ ____________ _________ __ __________ __________ __ __ ____________.
  __ _______ _____________ ______ ____ _____ _____________ _______ _________ ___________ ____ _____________ ______ _______ __.
  ______ _____ _________ ___________ _________ ____ _____ __ _____ _____________ __ ___________ _______ ________.
  ____________ _____ __ ___ _________ ____ __________.
  ______ ____________ _____________ ________ _______ __________ _____ _______ __ ____.
  _____________ ___ _____________ _____________ _________ ______ _______ ______ _______ ____ _______ ______ _____ __________ ____________.
  ________ _____________ _______ _________ _________ _________ _________ __________.
  _______ __________ _____________ __________ _______ ______ ____ ______ _______ ______ ________.
  _________ ____ ____ _____________ ________ __________ ________ ___________.
  ___ ____ _________ ___________ ___ _______.
  _______ ____ ___ ___ ____ __________ ___________ ____.
  _______ ___________ _______ ___ ____ ______ _______.
  ___________ ____ _____ __________ ________.
  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