hard20 pts · first answer countsdata-modellingschema-design

A company that buys and sells to you

Some companies are both customers and suppliers. Their name and tax ID are stored twice and often disagree. Which design removes the duplication?

A.Merge the customers and suppliers tables into one wide tableB.Keep both tables and sync them nightlyC.A shared party table, with customer and supplier roles linked to itD.Allow only customers or suppliers, not both

Discussion 0

Join free to post in the discussion.

A company that buys and sells to you

Discussion 0

Related questions