Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sustainability In The Hospitality Industry Principles Of Sustainable Operations

Authors: Willy Legrand, Joseph C Chen

2nd Edition

0415531241, 9780415531245

More Books

Students also viewed these General Management questions

Question

Behaviour: What am I doing?

Answered: 1 week ago