Need help for my database design

Like they said, from a normalization standpoint, I would agree it’s fine. From a practical/business standpoint, I would tie the payment to the massage booking table instead of the customer. Otherwise, the client will never be able to track whether a massage is paid for.

You can tie back to the customer table using joins if needed…

1 Like