This figure describes the object types in the OC subschema and their dependencies.

• The category_typ object type has the attributes category_name, category_description, and category_id.

• The customer_typ object type has the attributes customer_id, cust_first_name, cust_last_name, cust_address, phone_numbers, nls_language, nls_territory, credit_limit, cust_email, and cust_orders.

• The order_typ object type has the attributes order_id, order_mode, customer_ref, order_status, order_total, sales_rep_id, and order_item_list.

• The order_item_typ object type has the attributes order_id, line_item_id, unit_price, quantity, and product_ref.

• The warehouse_typ object type has the attributes warehouse_id, warehouse_name, and location_id.

• The leaf_category_typ object type has the attributes category_name, category_description, category_id, and product_ref_list. It references the category_typ object type.

• The composite_category_typ object type has the attributes category_name, category_description, category_id, and subcategory_ref_list. It references the category_typ object type.

• The catalog_typ object type has the attributes category_name, category_description, category_id, and subcategory_ref_list. It references the category_typ object type.

• The corporate_customer_typ has all the same attributes as the customer_typ object type, and in addition has an account_mgr_id attribute. It references the customer_typ object type.

• The product_information_typ object type has the attributes product_id, product_name, product_description, category_id, weight_class, warranty_period, supplier_id, product_status, list_price, min_price, catalog_url, and inventory_list.

• The inventory_typ object type has the attributes product_id, warehouse, and quantity_on_hand.