| Role I Service Fact| + | service line_id] | service_id | | service_type_id] | employee_id...

Transcribed Image Text:

| Role I Service Fact| + | service line_id] | service_id | | service_type_id] | employee_id | labor_cost I | service_start_date] | service_end_date I | total_service_price] I Part_Fact | service_line_id] |part_id I I part vendor I | unit_cost I part count | I | part_cost_at_service| Explanations: Bike_Type and Bike_Brand: Type 1 SCD is chosen because bike types and brands are unlikely to change. If they do change, a new record can be inserted. | Role I Service Fact| + | service line_id] | service_id | | service_type_id] | employee_id | labor_cost I | service_start_date] | service_end_date I | total_service_price] I Part_Fact | service_line_id] |part_id I I part vendor I | unit_cost I part count | I | part_cost_at_service| Explanations: Bike_Type and Bike_Brand: Type 1 SCD is chosen because bike types and brands are unlikely to change. If they do change, a new record can be inserted.