Question: Draw the ER diagram using an ISA relationship for the following example: Assume in a company, we have two kinds of staff, namely salaried -
Draw the ER diagram using an ISA relationship for the following example:
Assume in a company, we have two kinds of staff, namely salariedemployees and contractemployees. Both have a unique identifier SSN and a name. For salariedemployees we keep track of their yearly salary as well as the department to which they have been assigned to For contractemployees, we keep track of the number of hours they have a contract for, the hourly rate of pay, as well as the project number for the project in charge of this contract.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
