How does one create another transaction when all funds are tied up in an unconfirmed previous transaction?
It depends on your wallet software. Some may simply refuse to create the transaction. Others will spend the change output of the unconfirmed transaction. CPFP and RBF typically only occur when you specifically request for it in order to increase the fee of an unconfirmed transaction. Wallets will not do this automatically for you.