Consider the Following Two Tables Where EmployeeNum Is Primary Key

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 )