Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2 Part B Retiree Day Member Person Employee Gym Member Janitor Manager VIP Member Physical Therapist Standard Member You need to organize these entities into
2 Part B Retiree Day Member Person Employee Gym Member Janitor Manager VIP Member Physical Therapist Standard Member You need to organize these entities into a hierarchy that makes sense. Then draw a supertype/subtype hierarchy for them. Here are some rules: A person can be an employee, retiree and/or a gym member at once. These roles overlap with each other. So, for example someone can be a retiree, an employee and still have a gym membership. An employee can be a manager, janitor, typical worker employee or a physical therapist. They cannot have two or more job titles. Employees can only have one job title. You can say that none of the janitors are physical therapists or managers at the gym for example. You could also say that a typical worker is not a manager. A gym member can have one of three different types of memberships. They can have a day pass, be a standard member or be a VIP. The VIP members pay more money, but they get access to the physical therapists and yoga instructors. Every entity above is a human person. Employees are not given gym memberships for free as part of their employment. Save
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