Combining the following two tables would result in ____. 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

Combining the following two tables would result in ____.​ 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 )

Quizplus · Accepted Answer

The best choice would be to combine all the attributes into a single table. Therefore, the resulting table should contain all the attributes from both tables: EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, and PostalCode. This would result in the table structure as shown in choice B.

Combining the Following Two Tables Would Result in ____