What is the purpose of a primary key? What would happen if a relational database was designed without any primary keys?
What will be an ideal response?
Answer: The purpose of a primary key is to provide a unique identifer for each record in a relational database.
If a relational database was designed without any primary keys
- the same information may be entered multiple times in the database
- it would be difficult (maybe even impossible) to connect related tables
- data retrieved may be out of date and inaccurate
You might also like to view...
The overall purpose of the marketing plan is to enable the marketing manager to stay in touch with the three key parts of the business environment crucial to his or her success: customers, competitors, and factors outside the control of both
customers and competitors. Indicate whether the statement is true or false
In this kind of interview, the interviewer expects you to take most of the initiative and to give detailed and fairly long responses
A) ?Hostile or stress interview. B) ?Non-structured interview. C) ?Structured interview. D) ?Group interview.