@r937 , @DaveMaxwell
I need some help please to normalize my database,first of all please disregard the column address in each table.The requirements for these is to track the customer requested therapist,the customer can request no. of therapist.
Thank you in advance.
[quote=“jemz, post:1, topic:191839, full:true”]
@r937 , @DaveMaxwell
I need some help please to normalize my database[/quote]
what prompted you to ask this? where do you feel your tables aren’t normalized enough?
Yeah it looks normalized.
Thank you for your good feedback. I thought I was not able to normalized my table. I just asked because I am not strong in designing database.
Thank you.
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…
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.
