PDF 77-605 Dumps Exam Question 7
Peter works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer on which Microsoft Office 2007 is installed. The computer has a database named Sales. The database contains two tables, Employee and Department. Peter has to create a relationship between the two tables. Which of the following combinations of constraints should Peter use to accomplish the task?
A. Primary and unique
B. Unique and check
C. Default and foreign
D. Primary and foreign
In order to accomplish the task, Peter should use a combination of primary and foreign keys. A column in one table should be defined as a primary key and a column in the other table should be defined as a foreign key. The datatypes of both columns must
be the same.