1. An event organising company keeps track of deployment of its employees on various events. The following E-R diagram shows the relationship between entities of the event company:

<img src='./qimages/13949-1.jpg'>

You may make the following assumptions:

• All the events are only a day long.

• An employee may be deployed on many events.

• An event may have many employees deployed on it.

• Employee id and Event id are the primary keys of the Employee and Event entities respectively. Experience is input as number of years.

Perform the following tasks for the E-R diagram given above:

Design and implement normalised relations/tables for the E-R diagram. You should include primary key, validation checks and referential integrity constraints in your implementation.

Enter about 5 sets of meaningful data in each table.

Design and implement the following queries/forms/reports:

Create two forms -one for entering information about employees, while the other for entering information about events.

Find the employee name and designation of the employee who has maximum experience.

Find the list of all the employees who have been deployed on any event.

List all the events that were organized for the Host whose name is "Mohan". Show these events in the order of date.

List all the events that are scheduled on "01-12-2015" along with the list of employees who are deployed on them.