is it good practice to always use auto incremented primary keys to identify entities in a relational database. For example if an order is identified by three composite keys (customer_id, orderdateTime, orderItem) shouldn’t I just make a new surrogate PK order_id which identifies all other attributes?

​is it good practice to always use auto incremented primary keys to identify entities in a relational database. For example if an order is identified by three composite keys (customer_id, orderdateTime, orderItem) shouldn’t I just make a new surrogate PK order_id which identifies all other attributes?  Read More

​