discuss the implications of choosing composite primary keys over surrogate keys in database design, weighing the trade-offs between natural key attributes, such as business identifiers, and synthetic keys generated for the sole purpose of ensuring uniqueness and simplifying database management tasks?