Consider the Following Two Tables Where EmployeeNum Is Primary Key

question 10

Multiple Choice

Consider the following two tables where EmployeeNum is primary key in both tables. What is the result of combining the two tables??Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum) ?Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)

• A) Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, (Street, City, PostalCode) )
• B) Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)
• C) Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum)
• D) Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, EmployeeNum, LastName, FirstName, Street, City, State, PostalCode )