When opening my MacBook Pro, the Superdrive makes noise
There's an option to disable Super-drive in parental controls. Check in system preferences -> Parental control.

Edit
Ok if you want to do completely disable the superdrive without playing with parental control you can do it by unloading the kext file. Just go to /System/Library/Extensions folder and find IODVDStorageFamily.kext file. Move this file to any alternate location or create a new folder there itself and put it there and reboot. You won't see the superdrive in your connected devices again.  

To use the superdrive again, you need to put that file again on the same location and insert a USB drive, so that OSX starts searching for connected devices and it'll find your superdrive. Do take the backup of you kext file properly and do not delete it.