To me the multiple sequence would make sense, if I were to design an application. Think that you want to assign a unique number to the employee and a unique number to the dept. If you have one sequece you wouldn't be able to achieve this result. So by having two seqence numbers you would be able to uniquely diffrentiate the two table data.

I hope this would explain the things about sequence

Sam