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 )

Question

Quizplus · Accepted Answer

The two tables can be combined into one table with all columns from both tables, resulting in a table with columns: EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, and PostalCode. Option B is the only choice that includes all of these columns without duplication.

Consider the Following Two Tables Where EmployeeNum Is Primary Key