Under the normal DOS partitioning scheme, up to four primary partitions or three primary partitions and one extended partition containing as many logical partitions as you want. (In practice this is limited by the size of the disk.)
Whether the disk is IDE, SATA, SCSI, whatever is irrelevant.