2. Determine which attributes represent the primary keys and any alternate keys if any are present.
please help with question 2 this is for
" As you have asked for question number 2 among all the questions, so here I am answering only question 2"
primary Key:
In a schema, the primary key is the key that is unique for every row. It is a column that contains a unique identifying value for each column. A schema must have a primary key to perform the operations like- insert, update, and delete data from a schema or a database table.
Alternate Key:
A database table or Schema can have more than one column that contains a unique value for each row. In such a case, we select any one column as the primary key and the rest of the keys as the alternate or secondary key. Suppose there are three columns that contain the unique value, then one will be primary and the rest two will be alternate keys.
Step by step
Solved in 2 steps