Why do we designate one of the candidate keys of a relation to be the primary key?

Define the following terms as they apply to the relational model of data:domain, attribute, n-tuple, relation schema, relation state, degree of a relation, relational database schema, and relational database state. Why are tuples in a relation not ordered? Why are duplicate tuples not allowed in a relation? What is the difference between a key and […]