A nested schema is shown. CustomerOrder is expanded to CUSTOMER and CUSTOMER_ORDER. CUSTOMER is expanded to CUSTOMER_ID, FIRST_NAME, LAST_NAME, and SSN. CUSTOMER_ORDER is expanded to ORDER_ID, C_ID, TOTAL_ORDER_AMT, and STATUS.