Define the term primary key and alternate key with respect to database.
Question
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Welcome to the ever growing Protoedu family of knowledge seekers and torch bearers. The Protoedu family surpasses the mundane boundaries set by political interests because the Protoeduers (Protoedu family members are fondly known as ) only believe in one concept - Sharing is Growing Asking is Glowing Hearty Welcome once again !!
Answer ( 1 )
An alternate key is a key associated with one or more columns whose values uniquely identify every row in the table, but which is not the primary key. For example, where the primary key for a table may be the employee id, the alternate key might combine the first, middle, and last names of the employee.
A primary key is a column — or a group of columns — in a table that uniquely identifies the rows in that table. For example, in the table below, CustomerNo, which displays the ID number assigned to different customers, is the primary key. CUSTOMERS.