In-Class Lab 1. Consider the entity set Employee with attributes empld, socSecNo, emp_name, jobtitle, and salary. a. Show how the entity set and its attributes would be represented on an E-R diagram. b. Describe the domain of the salary attribute, making assumptions as needed. c. Identify a superkey for the Employee entity set. d. Identify al candidate keys for the entity set. e. Identify a primary key for the entity set and underline it on the E-R diagram. 2. a. Assume in the same enterprise as in Exercise 1, that there is an entity set called Project with attributes projName, startDate, endDate, and budget. Show how this entity set and its relationship to Employee would be represented on the E-R Diagram. Assume you want to represent the number of hours an employee is assigned to work on a project, and show that in the diagram b. Stating any necessary assumptions, make a decision about the cardinality and participation constraints on the relationship, and add appropriate symbols to the E-R diagram. c. Assume there is another entity called Department to be added. Each employee works for only one department. A department does not directly sponsor projects. Making up attributes as needed, add this entity and appropriate relationship(s) to the diagram