RelationalDBDesign RelationalDBDesign 


Performance Tuning  «Prev 

FactFile - Database

FactFile database consists of the following 6 tables. 1) PRODUCT_OBJ_TABLE, 2) CUSTOMER_OBJ_TABLE, 3) SALE_HEADER, 4) PET_CARE_LOG_OBJ_TABLE, 5) MONTHLY_SALES, 6) PRODUCT_PHOTO_OBJ_TABLE.

The Pet Store Database consists of a series of tables which are described below.
  1. The PRODUCT_OBJ_TABLE can be viewed by clicking on the following link -> product-object-table
  2. The CUSTOMER_OBJ_TABLE can be viewed by clicking on the following link -> customer-object-table
  3. The SALE_HEADER can be viewed by clicking on the following link -> sale-header
  4. The PET_CARE_LOG_OBJ_TABLE can be viewed by clicking on the following link -> pet-care-log-object
  5. The MONTHLY_SALES can be viewed by clicking on the following link -> monthly-sales
  6. The PRODUCT_PHOTO_OBJ_TABLE can be viewed by clicking on the following link -> product-photo-object
  7. All Data Tables can be viewed by clicking on the following link: -> data-tables