Originally Posted by simward

[code]
customer(idCustomer, nameClient, firstNameClient, ...)
product(idProduct, nameProduct, ...)
rma(idRma, registeredDate, idCustomer_customer, idProduct_product)
provider(idProvider, nameProvider, ...)
order(idOrder, registeredDate, receiptDate, ...)

An order has MANY products and each product in the order has his "UNIQUE" serial number (different products could have the same Serial)
...