Role I Service Fact service line id service id I service type id employee id I labor cost I service start date service end date

Question

Role I Service Fact service line id service id I service type id employee id I labor cost I service start date service end date I I total service price I Part Fact I service line id I part id I I part vendor I I unit cost I I part count I 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

Kunduz · Accepted Answer

Click to see the answer