Description of the illustration comsc009.eps

This figure shows the structure of schema PM and its relationships with table oe.product_information.

The online_media table has the following attributes:

• Columns: product_id(primary key), product_photo, product_photo_signature, product_thumbnail, product_video, product_audio, product_text, product_testimonials. Note that the type for product_photo_signature, ORDImageSignature, has been deprecated.

• Other Relationships:

  • Column product_id relates one or more rows of the table online_media to one row of the table oe.product_information with the corresponding value of product_id.

The online_media table has the following attributes:

• Columns: product_id(primary key), ad_id, ad_composite, ad_sourcetext, ad_finaltext, ad_fltextn, ad_textdocs_ntab, ad_photo, ad_graphic, and ad_header

• Other Relationships:

  • Column product_id relates one or more rows of the table print_media to one row of the table oe.product_information with the corresponding value of product_id.