SQL Query Multiple Tables

I have 5 tables,

Machines(ID, Name),

Engineers(ID, Name),

Parts(ID, Name),

Faults(ID, MachineID, EngineerID, Description, Date),

FaultParts(FaultID, PartID)

Key = Primary (bold), Foreign Key (italic), Composite (italic & bold)

A fault can require more than one part to fix it

I am trying to query the database so that I can retrieve the the engineer name, machine name, fault description, and parts requires to fix.

I am unsure how I should go about doing this efficiently or if may tables should be set up as they are.

Any help would be greatly appreciated, thanks.