Suppose you have the following two tables where EmployeeNum is the primary key in both tables. What can you say about the EmployeeBuilding table??Employee (EmployeeNum, LastName, FirstName)?EmployeeBuilding (EmployeeNum, BuildingName)?FK EmployeeNum - Employee
A) The EmployeeBuilding table is a subtype of the Employee table.
B) The EmployeeBuilding table is a supertype of the Employee table.
C) The Employee table is a subtype of the EmployeeBuilding table.
D) BuildingName is a subtype discriminator.

Question

Suppose you have the following two tables where EmployeeNum is the primary key in both tables. What can you say about the EmployeeBuilding table??Employee (EmployeeNum, LastName, FirstName)?EmployeeBuilding (EmployeeNum, BuildingName)?FK EmployeeNum -> Employee
A) The EmployeeBuilding table is a subtype of the Employee table.
B) The EmployeeBuilding table is a supertype of the Employee table.
C) The Employee table is a subtype of the EmployeeBuilding table.
D) BuildingName is a subtype discriminator.

Quizplus · Accepted Answer

The EmployeeBuilding table is not a subtype or supertype of the Employee table; instead, it is related to the Employee table through a foreign key (FK) relationship. This means EmployeeBuilding contains additional information (in this case, BuildingName) related to each employee, indicating a kind of extension or detail table rather than a subtype/supertype relationship. The concept of subtype and supertype is related to inheritance and specialization in database design, which is not what is being described here.

Suppose You Have the Following Two Tables Where EmployeeNum Is