i'm developing a system that uses transactions to relate tables called equipment to customers.
obviously this is a many-to-many relationship and there needs to be a table inbetween these tables which i will call lineItem.
now i believe there should be yet another table that i will call transactions. within this transactions table will be a record for each transaction that takes place. so transactions holds a record for each transaction, lineItem holds a record for each item within the transaction.
i think i should relate the customer table directly to the transaction table. am i right? if i were to relate it to the lineItem table, then i would have a lot of redundant information.
here is a link to a diagram that i made: