Our group has been developing a webapp to take it live in the future. We got stuck at normalizing a few tables, as it could involve redundancy.
We have some tables that I describe as follows:
- shipping table: the address attributes and ID being the primary key.
- order table: few attributes along with address attributes and oID being the primary key.
- payment/card table: few attributes along with address attributes and pID being the primary key.
Is this in normalized state or do we have redundancy here?