Categories
Database Development

Am I over normalizing?

Suppose a payments transaction system where the transactions can be between users on the platform (Customer-Customer, Customer-Merchant, Merchant-Merchant) and users AND the platform (Customer-Platform, Merchant-Platform for top-ups/withdrawals/fees etc.). Users: User |user_id|basic user information| Customer |uses basic User model| Merchant |merchant_id|user_id|other merchant fields| Wallets: Wallet |wallet_id|balance| UserWallet |wallet_id|user_id| MerchantWallet |wallet_id|merchant_id| Since transactions might not always be […]