Design normalized tables in 3NFfrom the ER diagram drawn in part (a), with the required integrity constraints. 

Word Count : 522

---

Based on the ER diagram provided earlier, here is a design for normalized tables in 3NF (Third Normal Form) for the Book Store scenario:

Table: Book

• Attributes: book_id (primary key), title, author, genre, publication_date, price, publisher_id (foreign key)
• Constraints: Each book has a unique book_id. The publisher_id references the Publisher table.

Table: Publisher

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

Table: PurchaseOrder

• Attributes: order_id (primary key), publisher_id (foreign key), order_date, total_amount
• Constraints: Each purchase order has a unique order_id. The publisher_id references the Publisher table.

Table: OrderItem

• Attributes: order_item_id (primary __ ____ ___________ _______ ____ ________ _________ ________ _______.
  __ __________ ___ ________ ____________ _____ ____________ ______.
  __________ ____ ________ _______ __________ _________ ___ ________ _______ _________.
  ________ __ __________ _____ __ ________.
  ___________ ________ _______ _______ ________ _______ ___ ____________ ____________ ____ ______ _____________.
  _______ _____________ _________ _____________ __ _____ _________ _____ _____.
  _________ _____________ __ _____ ____________ _____________ _________ _____________ ___________ ___________ ____.
  _____ ___________ __ _____________ _____________ ______ _____________.
  ____________ ___ ____ ___ ___ ________ ________ _____________ ____.
  ________ __________ ________ __ ___________ ____.
  ___ ______ _____________ ___ ________ ____________ __________ _____.
  ____________ ______ ____ __ ____ __________ ___________ _______ _________ _____________ _______ __ ___ ________ _____________.
  ___________ ____ _____ _______ _________ __________ _____ _______ ___ _____________ ___________ _____.
  _____ __________ _____ ____ ___ ______.
  ____ ______ ____________ ________ __ ____________ ________ ______ __________ ___________ ________ ____.
  _____________ _________ __________ ____________ _______ ___________ ______ __ ___ __________.
  ____________ ____ _____ _______ _______ ____________ ___ ______ ____ _____________ __________ ________.
  ______ ___________ ________ __________ ___ ____________.
  ________ ____________ ________ ____ ___ ________ __________ ____ _________.
  __ ________ __ ____________ __ _____________ _____________ __________ _____________ _____ ________ ______ __________ __________ _____________.
  _____ _________ ________ ___ _____ _________.
  _____________ ____________ ___ __ _____________ ___________ __ ______ _____ ___ _________ ______ ___________ __________ __.
  ___________ ________ ______ ____________ ____ ___ ____________ ____________.
  _______ _________ ___ _____________ ___________ _____________ _____________.
  ___ __ _____ ______ _____________ _____________ ______ ___ _______ _______ ___ ________.
  ____ _____ _______ ______ ____ _____.
  __________ _________ _____ _____ _________ ___________ ___________ ______.
  ________ ________ ____________ ___________ __ ______ ___________ _________ _______ ________ __.
  ________ _____________ _________ ___________ ______ ______ _____________ _________ __ _____.
  _____ ___ _______ ________ ______ ____ ______ ______ _____________ __________ ____ ________.
  ____________ __ _______ _______ ____________ __ ____ _____________ __________ __________ _____________.
  ____ ___________ ________ ____ __________ ____ __ _____ _____________ ___ _____________ _____________ __________.
  _____ ________ _____ ___________ _________ _____ ___________ _________ _____________ _____________ _____________ _______ ___________ _____ ________.
  _____ _____________ _______ _____________ _____________ _____ __ _______ _________ __________ ___ ____________.
  ___________ _________ __________ _______ _____ _____ ___ _________.
  ___ ___________ ___ ______ ________ ____________ ___________ ____ ____ __ __________ _____ ____.
  ____ ______ ____________ ___ ___ _____________ ____ __________ ______ _______ ______ ____________ __________ ___________.
  ________ ___________ _____ ________ __ _______ ____________ ___ _____ ____.
  _______ ___ ___________ ___ ______ __________ ___ __.
  _____ ____________ ____ ______ ___________ ____________ ________ __ __________.
  __________ _________ _____________ _________ _________ _____________ __________ _______ ____.
  ____________ _________ __ __ __________ _________ __ _____ ___________.
  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