It’s actually really easy for a developer and for a user. Apps can provide a notification sound for themselves, but the Android API automatically creates a user interface inside of the notifications settings that let a user set a sound of their choice on a per-notification-channel (for example, Discord has separate channels for “Incoming calls”, “Direct messages”, “Friend requests”, and a heap more) basis.