Database design and optimisation Undergraduate

Design and implement a database to store personal trainer booking.

Design and implement a database to store personal trainer booking for a gym and client/server software system in Java to interact with the database. The client program should have an intuitive user interface to add, remove and manage bookings. The server program should allow multiple clients connect at the same time and interact with database (see the scenario below)