I'm skipping over Sparrow's and also Piggeh's because I must correct the incorrect facts
Science
Only stars with a mass of 8 solar masses or greater (That's the mass of our sun*8) can produce a supernova, and only in truly massive stars around 15 solar masses and above can black holes form. The sun in time would actually become a red giant, develop multiple shells of helium and other denser elements and then throw them all off, leaving its carbon core behind in white dwarf form.