Multiple Choice
If you combine the two tables shown above,the result would be ____.
A) Employee (EmployeeNum ,LastName,FirstName,WageRate,SocSecNum,DepartmentNum,(Street,City,Zip) )
B) Employee (EmployeeNum ,LastName,FirstName,WageRate,SocSecNum,DepartmentNum,Street,City,State,Zip)
C) Employee (EmployeeNum ,LastName,FirstName,Street,City State,Zip,WageRate,SocSecNum)
D) Employee (EmployeeNum ,LastName,FirstName,WageRate,SocSecNum,DepartmentNum,EmployeeNum ,LastName,FirstName,Street,City,State,Zip )
Correct Answer:

Verified
Correct Answer:
Verified
Q1: A(n) _ is essentially both an entity
Q23: When the existence of one entity depends
Q34: During the _-level design, designers must consider
Q39: The properties of the entities you choose
Q44: You can recognize entity subtypes by the
Q45: When designing a database,you might find it
Q46: The basic relationships are one-to-many,many-to-many,and one-to-one. How
Q48: Foreign keys allow you to create relationships
Q64: When a DBMS creates a(n)_ key,it is
Q73: In a one-to-many relationship, the primary key