Question
A company has only three types of employees: part-time, full-time, and consultants, each with the following attributes: Part-time employees: EmpID, Name, DateJoined, HourlyRate Full-time employees:
A company has only three types of employees: part-time, full-time, and consultants, each with the following attributes: Part-time employees: EmpID, Name, DateJoined, HourlyRate Full-time employees: EmpID, Name, DateJoined, Salary, JobCode Consultants: EmpID, Name, DateJoined , ConRate, SkillCode Each employee in this company belongs to exactly one of the three types. To model this business situation, you need to use enhanced E-R diagram. Answer the following questions related to design an enhanced E-R diagram.
1. Which entity should be modeled as the supertype entity? Which entities should be modeled as the subtype entities?
2. What attributes should the super type entity have in the enhanced E-R diagram?
3. What disjointness constraint does the supertype/subtype relationship use? How do you interpret this constraint?
4. What completeness constraint does the supertype/subtype relationship use? How do you interpret this constraint?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started