tests: posix: common: split POSIX_SYSTEM_DATABASE into a standalone test #81489
Description
Is your enhancement proposal related to a problem? Please describe.
Make the posix-system-database-related tests in tests/posix/common into a standalone test.
Describe the solution you'd like
The obvious way to group posix-system-database-related testsuites is by POSIX_SYSTEM_DATABASE Option Group.
Describe alternatives you've considered
The way the testsuite has been designed historically.
Additional context
See #79454 for more info