Consider the entity set Employee with attributes empld, soc-SecNo, empName, 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 all candidate keys for the entity set. e. Identify a primary key for the entity set and underline it on the E-R diagram. a. Assume in the same enterprise as in Exercise 3.2, that there is an entity set called Project with attributes projName, startDate, end-Date, 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 of 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. Projects are not directly sponsored by a department. Making up attributes as needed, add this entity and appropriate relationship (s) to the diagram