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

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 key), ________ ________ ________ ______ _________ _______.
  ___ ____ ______ ____ ___ ________ _______ _______ _______.
  ____ __________ ________ __________ ___ __________.
  ______ _______ ______ ___ _______ ______ ______ _____ _________ _________ ________.
  _____ _____ ____ ____ _____ ____ _____ _______ __________ _____.
  _________ __________ ________ _____ ___ ___.
  ____ ________ _____ _________ ______ _______ _________ _______ __________ ____.
  ____ _____ ____ _______ ____ _____ _________ __________.
  ___ _______ _____ _____ ___ ________ _______ ______ ____ ______.
  ______ ________ _______ _________ ____ __________ ____ _______ ______ ___.
  _______ ________ ______ __________ _______.
  ________ _________ ______ ________ ___.
  _______ _________ ___ ___ ______ ________ _________.
  ________ _____ ________ _____ ____ _______ __________.
  _______ ___ ____ _________ ________ ______ ________ ___ ____ _______.
  _________ _________ _______ ______ _____.
  ______ __________ ______ ______ ___ ___ ____ ______ ___ __________ __________.
  ________ _______ __________ ________ ________ _____.
  _____ _____ ________ ____ ________ _________.
  _____ ____ ____ ______ _______ _______.
  ________ ________ _______ ____ _______ __________ ______.
  _______ _______ ____ _____ _________ ________ ___ ______ _____ ___ __________ _______.
  ______ _________ _________ _________ ________ _____ ______ _____ ____.
  _____ _______ ____ ______ ________.
  _______ ________ ______ _________ _____ _______ ________ ________.
  __________ __________ ________ ______ ________ _____ ______ ________ __________ ____ _________.
  ______ ____ __________ ___ __________ _____ _________ __________.
  ______ __________ ______ ____ _____ ___.
  ____ _____ __________ ________ ______ ___ ________ ________ _____ ________.
  ___ ___ ______ ______ _____ _____ __________.
  ___ ____ _________ ___ __________ _________.
  ________ _______ ______ ________ _____.
  ______ ____ _______ _____ ____ ____.
  ___ ____ ______ _________ _____ ________ _________ __________ ___ ____.
  __________ _________ ________ __________ ______ ____ ________ _________ _______ _________ ______.
  ________ _____ _______ ______ ___ __________ _________ _______ ____ ________ _______.
  __________ _____ __________ ___ _____ ____.
  _____ _____ ___ _________ _____.
  _______ _______ ____ ____ _______ ____ _______ ______ ____ _________.
  _______ ___ _______ ____ _________ ____ ________ ____.
  _________.
  Get Full Answer on WhatsApp