Question: ER diagram for this application The customer should be able to do the following functions: Register / login Browse workshops See the workshop evaluation Workshop

ER diagram for this application

The customer should be able to do the following functions:

  • Register / login
  • Browse workshops
  • See the workshop evaluation
  • Workshop selection
  • Communicate with the workshop inside the application
  • Accept / reject offers
  • Writing a review
  • Communicate with Customer support
  • Cancel an existing order on limit time
  • View his page
  • Place offers on offers page

The Owners should have following management functionalities:

  • Owner FUNCTIONS. Get all customers who have booked. Get all flights for a given airport. View booking schedule.. Calculate total sales for a given booking.

Calculate total sales for all bookings.

receive direct messages.

Send and Cancel and accept offers from offers page .

  • ADMIN Add/Delete a workshop Add a new category Update fare for workshops. Update departure/arrival times for workshops.

Delete a review.

Cancel orders

Access to Direct Messages

add/edit Location of workshop

add/edit Name of workshop

add/edit Specialization

add/edit Specialization

Flexible Date/time booking

Confirmation

View his account

Each workshop has a limited number of available cars. There are a number of booking which depart from or arrive at different cities on different dates and time.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!