I am new here, but also learning SQL right now. I was reading in my book reviewing for a quiz over book terms, but I noticed a term referred to as a composite primary key. I know the what, but why is it called a composite primary key?
My book says a composite primary key has "two or more columns"... If the number of columns were "composite" wouldn't the number 2 not be even in the picture here? Wouldn't the number of columns only be composite numbers?
I guess I am trying to understand why it's called that. Is this term just one of those "because that's how it is", or is there meaning or a story behind this one?