I have UML for various system designs, most notably OO Java based developments but also for relational systems with front ends as diverse as Cold Fusion, PhP and Mendix. Within UML I’ve used case diagrams, use case, activity, state transition and system topology diagrams and products such as TogetherSoft and Rational Rose:
