Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. Table part
Resolve Tasks

Instruction

The second table, part, stores details about the Ford car parts for sale in Terry's store.

Exercise

The part table shows hierarchical information about the car parts. It contains these columns:

  • id – the unique ID of the part.
  • name – the name of the part.
  • price – the price of the part.
  • registered_date – the registered date of the part.
  • model_id – the Ford model (universal parts for all models have NULL in this column).
  • parent_id – the ID of the parent part, if any (main parts have NULL in this column because they don't belong to any parent part). For example, the car body is a parent part built of an engine and other parts, and an engine is a parent part built of cylinders, pistons, and other parts.

Explore the contents of the table part by selecting all data from it.