PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which of the following factors lead you to define an artificial key for use as a primary key in the Info table

You work as a Database Designer for Tritech Inc. You are designing a table named Info. The table
contains the following attributes:
Login and Password
Name
ContactNumber
Address
Each new employee joining the company is assigned an E-mail Login and Password. This E-mail Login
and Password is used by each employee
to access his account on the company’s Web site. The value of both the attributes should be unique
and cannot be NULL. You design an
artificial key EmpID in the Info table to serve as a primary key. Which of the following factors lead
you to define an artificial key for use as a
primary key in the Info table?
Each correct answer represents a part of the solution. Choose all that apply.