Please complete the design below using the modified Chen diagram. You must use a graphical program of your choice (such as the shapes and text boxes provided in word). Nothing hand-drawn.

1. Restaurant - You have a friend who owns a restaurant and he is having trouble keeping track of various information. He has a program to keep track of reservations but does not have anything to keep track of banquet/party information. Recently a group of people showed up for an event that was not on the calendar.

The types of things he needs to know are:

• All banquets/parties that are scheduled for a specific period of time. This includes all information about the party, (price, date, number of people, contact name, etc
• Which employees are assigned to the various parties
• Which employee booked all of the information for the various parties
• Which meal choices have been ordered for the various parties. The restaurant only offers specific meal options for parties, but the customer may choose up to three entre choices. The restaurant owner needs to know how many of each entree must be prepared for the party.
• The owner would also like to send out a discount coupon to those who have booked a party. The discount will be available for any parties they may book in the future.

You must store all of the above information

Draw the ER-Model and indicated the functionality of any relationships.

Do not model any other information than what is described above