Which of the following shows sample DBDL documentation for the Employee table?
A) Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)
B) Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)
C) Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, (WageRate, SocSecNum, DepartmentNum) )
D) Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum, DepartmentNum)
AK SocSecNum
SK LastName
FK DepartmentNum→Department

Question

Which of the following shows sample DBDL documentation for the Employee table?​
A) ​Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)
B) ​Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)
C) ​Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, (WageRate, SocSecNum, DepartmentNum) )
D) ​Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum, DepartmentNum)
AK SocSecNum
SK LastName
FK DepartmentNum→Department

Quizplus · Accepted Answer

This option lists all the attributes of the Employee table along with their data types. It also includes foreign keys for Department and does not include any redundant information.

Which of the Following Shows Sample DBDL Documentation for the Employee