Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Figure E4.l shows an IE model for the health spa example in Exercise 3.2. Translate the IE model to a UML model. Note the following

Figure E4.l shows an IE model for the health spa example in Exercise 3.2. Translate the IE model to a UML model. Note the following about the moclel: TherapistPreference Customer customerlD (FK) customerlD favoredTherapistlD (FK) ~>--+i--c-u-s-to_m_e_rN_a_m_e---Jt---ClE:j TreatmentPreference customerlD (FK) favoredreatmentlD (FK) WorkSession workSessionlD workDate startime endime therapistlD (FK) 1.-------------, Appointment Therapist therapistlD f----" 1------------1 appointmentlD startDateTime discountPercent discountAmount subjectlD (FK) treatmentlD (FK) therapistlD (FK) roomlD (FK) therapistName healthSpalD (FK) 1- - - - - - - 1 HealthSpa Room healthSpalD 1- - - ,-w,: roomlD ,__ ____ _, roomNumber healthSpaName healthSpalD (FK) TheraplstQualiflcatlon therapistlD (FK) treatmentlD (FK) Payment paymentlD paymentAmount paymentype paymentDate appointmentlD (FK) payerlD (FK) Treatment treatmentlD treatmentName duration listPrice

Extend the spa model by adding a generalization for different kinds of payments (credit cards, debit cards, cash, gift certificates).

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_2

Step: 3

blur-text-image_3

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

Intelligent Information And Database Systems Second International Conference Acids Hue City Vietnam March 2010 Proceedings Part 1 Lnai 5990

Authors: Manh Thanh Le ,Jerzy Swiatek ,Ngoc Thanh Nguyen

2010th Edition

3642121446, 978-3642121449

More Books

Students also viewed these Databases questions

Question

Discuss the effect of day care on children.

Answered: 1 week ago