Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?
If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].
Is it permissible to single out Fridays, Saturdays, and Sundays to make up for missed fasting without fasting a day before ,or after each ?
Yes, it is permissible to make up for missed fasting during the aforesaid days, and it is also valid to offer non-obligatory and vowed fasting as well. However, fasting a day before or after each isn`t obligatory. And Allah Knows Best.
Is it permissible for the mother to offer an Aqeeqah (the sheep slaughtered on the seventh day from the child`s birth)for her son?
Aqeeqah is due on the one obliged to provide for the newborn, and it is permissible for the grandfather, or the mother to offer the Aqeeqah.
What should one who made an intention, at night, to make up for a missed fasting day, but broke his fast on the next day?
One who started making up a missed fasting day, then broke his/her fast without a legitimate reason is considered sinful, and is only obliged to make up for the missed fasting days. And Allah Knows Best.