During the last couple of hours of pregnancy, your pregnant Sim will not be able to do anything, and will automatically head home. When the baby starts coming the mother will grasp her stomach and moan, and give birth after a couple of hours. She will also gain a positive moodlet called "Baby Is Coming", but it doesn't gives any Focus boost.
In The Sims Medieval, there is no hospital, so the mother will have to have a home birth. The player does not get to choose the baby's traits or fatal flaws. After giving birth, the mother will get a +80, 24h moodlet which tells the gender of the baby.