Yes, libnss3-1d depends on libsqlite3-0. If libsqlite3-0 is missing, libnss3-1d is simply broken. This problem may not be apparent at link time because libsoftokn3.so (the NSS shared library that depends on libsqlite3-0) is not loaded until you call one of the NSS initialization functions. If you can't load libsoftokn3.so, NSS initialization fails, and you can't call any NSS function.
Yes, libnss3-1d depends on libsqlite3-0. If libsqlite3-0 is missing, libnss3-1d is simply broken. This problem may not be apparent at link time because libsoftokn3.so (the NSS shared library that depends on libsqlite3-0) is not loaded until you call one of the NSS initialization functions. If you can't load libsoftokn3.so, NSS initialization fails, and you can't call any NSS function.