I wonder if anyone can help me and I hope I am posting in the right place, forgive me if not.
I have a fairly complicated scenario but to simplify it, I have a Customer table which is connected to Order table.
Staff members can be customers and they get staff discount for their orders.
How do I design my tables to show this? Do I store the same staff data again in Customer table or is there a way these can be connected. N.B. Extra data is collected about staff.
May be the solution is very simple and I am missing it because I thought too much about it, so ANY suggestion is very welcomed :)