The blog Music Thing once did a short series of posts called "Tiny Music Makers" that gave some background to the creation process of famous small sounds.
My favorite quote from it, about the Intel Inside chimes:
In less than three seconds, they wanted "tones that evoked
innovation, trouble-shooting skills and the inside of a
computer, while also sounding corporate and inviting".