Consider the EMPLOYEE entity type given below.

a. List all key and non-key attributes.

b. What is (are) the unique identifier(s)?

c. Which attribute(s) is (are) derived attributes?

d. Using the figure in Exercise 9 as a guide, develop sample data for four employees that illustrate the nature of the various mandatory and optional attributes in the EMPLOYEE entity. Be sure to illustrate the various ways the Name attribute might appear.


You must be registered and logged in to an account to download solution 


[purchase_link id=”8794″ style=”button” color=”blue” text=”Purchase”]