Sample Header Ad - 728x90

Breaking Down Transaction Table

0 votes
1 answer
40 views
My table transation consists of tranxid, custid, itemid, quantity, unit_price, payment mode, driverid. When I perform add operations and notice that customer 1 can buy at least one or two items more and so on. There is some duplication for the custid, itemid, driverid and payment mode. How can I resolve this duplications? Can I use the one to many/many to one relationship to split the transaction table into two table?
Asked by Wei Xiang Ng (1 rep)
Sep 6, 2024, 12:12 AM
Last activity: Sep 6, 2024, 07:50 AM