1. A candidate is interviewed by many companies for selection of suitable job. The following E-R diagram shows this:

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

A candidate can appear for interviews conducted by many companies. One company can interview many candidates. However, one candidate can appear for interview of one company only once.

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

Design and implement normalised relations/tables. You must include primary key, validation checks and referential integrity constraints in the relations/tables.

Enter 5-6 sets of meaningful data in every table created by you in part(a).

Design and implement the following queries/reports/forms for the database so
created:

Create two forms one for entering candidate information and other for entering company information.

List the candidates whose highest qualification is "Post Graduate".

List the candidate name, company name and job of those interviews which are to be conducted on 1st July 2016.

List the Candidate_ID and name of those-candidates who have appeared for the interview conducted by company whose Company_ID is "C001".

Create a report of name of companies in alphabetical order.