[CHORE] Remove Cross Dependency from Tests

[Schmarvinius]

Many tests have a cross dependency due to no resetting of the database. This is a bad practice and should be removed for test quality purposes.
Problems that could happen:

• If an early test fails, all tests building on the failed test, do as well.
• Harder debugging.
• Maintenance is more complex since changing one test affects the others eventually.

[github-actions]

👋 Hello @Schmarvinius, thank you for submitting this issue. Our team is reviewing your report and will follow up with you as soon as possible.