i want to make a simple database for online shopping however i am confused about certain points
i know i need to have a customer entity , product entity and order item entity.
According to my understanding many customers can order many products and when the same customer orders later on he needs to be assigned a new order id along with the product id so that calls for a composite key but what i specifically lack in is defining relationships and cardinality.
can some one please help me structuring the design for the shopping cart .
thanks in advance