Design a generalization /specialization hierarchy for a Computer Peripheral sales company. The company sells monitors, printers, scanners and UPS. Justify your placement of attributes at each level of the hierarchy. Convert the diagram into tables with integrity constraints for each table

Generalization / Specialization Hierarchy:

            Computer Peripheral
                    |
            -----------------
            |       |       |
         Monitor  Printer  Scanner  UPS
The general category is "Computer Peripheral", which is then specialized into four types of products: "Monitor", "Printer", "Scanner", and "UPS".

Attributes for each level of the hierarchy:

• Computer Peripheral: This is the most general level and would include attributes that are common to all the products sold by the company, such as product ID, name, description, and price.
• Monitor: This level would ___ _______ ______ ________ ________ ____ ______ ___ _________ _______.
  ___ __________ _________ _____ ___.
  __________ __________ ______ ________ ____ _______ _____ _______.
  _________ _____ ______ _____ ______ ____ ________.
  ____ ____ _________ ______ _______ ____ _______ ________ _______.
  __________ ________ ____ ________ ____ _____ ________ ________ _______.
  ________ ___ __________ ____ _________ ______ ________.
  ________ _________ ___ ___ ___ __________ __________ ____.
  ___ ____ ____ _______ ______ ____ __________ ______ _______ __________.
  __________ __________ _______ ______ _________ ______.
  ___ _______ ____ _________ ____ _____ _____ _______ ___ ______.
  ____ ___ ___ _________ ___.
  ______ ________ ____ ___ ______ ________ ___ _____ _________ ____ ___ _____.
  __________ ____ ___ ________ __________.
  _________ ______ _____ _________ ____ ___ ________ _____ ________ __________.
  _____ _________ ______ ______ ________ ________ ____.
  ________ _________ ______ _________ _____.
  _______ _________ ____ _________ _________ ___ ________ ___ _____ _______ ___ _________.
  _______ ____ _______ _______ _____ __________ ____.
  _____ ___ _____ __________ _______ _____ ____ _____ ______ ______ _________.
  _____ ______ ____ ____ ______ ___.
  __________ _____ ____ _________ _____ _______ ___ _________ ______ _____ ______ ____.
  __________ ___ _________ ______ _____ ________ _______.
  ____ __________ ________ _______ _______.
  ____ ____ _____ _________ ____ _______ ___ ____.
  _____ _____ ___ ___ ________ __________ ___ ________ _______ ____ ___ ____.
  ______ ____ ______ _____ ______ __________ __________ ___.
  _________ _________ _________ _____ _____ ____.
  _____ _____ __________ _____ _______ __________ __________ ______ _________.
  ___ ___ __________ _______ _______ _________ __________ ________ ___ ___.
  _______ _________ _______ _______ ______ ________ _____ _______ ___ ______.
  _____ _____ ________ ____ ______.
  __________ ____ _________ ________ _________.
  _________ _________ _________ ________ ____.
  _____ _______ _________ _________ ________ ____ __________ __________ ________ _______.
  ____ __________ ___ ___ __________ _____ _______ __________ _____ ____ ______.
  ___ ___ _______ ________ ______ _____ __________.
  ______ ___ _____ _________ _______ _____ __________ _________ _______ ______.
  ___ __________ ___ _________ _____ _____ _____.
  ___ ________ _________ ______ _________ ______ _______.
  __________ _______ _________ _________ _______ ________ __________ __________ ________ _____.
  __________ ______ __________ ___ _________ ______ _________ _______ __________ ___.
  _______ ________ ________ _______ ____ ____ ______ _________ __________ _________ _______.
  _______ ____ _____ ______ __________ _________ ___.
  ________ _____.
  Get Full Answer on WhatsApp