DDD

Question 1

How does a compound key work

Answer 1

Let say you and another person bought an item from a business and lets say that it had a generator generating different number/letter codes for the customerID and PurchaseID

and you both had the same customerID but not the same PurchaseID
you would need to join the customerID and PurchaseID up to make it unique

this is called the formation of a compound key yung bruddah.

Question 2

What are the things to know about a compound key?

Answer 2

• A compound key can be made out of multiple (meaning more than 2) primary keys
• attributes that are used to make up a compound key is a primary key in its own right
• Compound key is known as 2 or more attributes used to identify a record in a table