Add database transaction safety for multi-step updates

[nanaf6203-bit]

Wrap multi-step updates in transactions to prevent partial writes.

Acceptance Criteria:

• Multi-step operations use Prisma transactions.
• Failure in one step rolls back all changes.
• Critical update flows are reviewed for atomicity.
• Tests simulate partial failure rollback.