View the step-by-step solution to:

Question

The tennis club wants to extend/modify the database to include further information. They describe the key elements

of their requirements in the following points:

 Members have a unique member ID, and have a name, address and phone number

 Some members are VIP with a discount amount recorded

 The club now has several additional courts. Each court has a unique courtNo, and has dimensions, a surface type (eg clay, grass, asphalt etc) and a venue type (indoor/outdoor)

 The club has several in house coaches, each with an empNo and name. Coaches can now have several specialities, with a certain number of year of experience for each speciality

 Members can make bookings for any of the club's tennis courts (and do not necessarily have a coach present, though they can still have a coach present during the booking if they choose)

 Each booking is for a specific date and time, duration and fee

Draw the ER (UML class) diagram for the updated tennis club model. You are strongly encouraged to use Lucidchart to produce the diagram

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question