Question: Please Solve Fast a. Consider the following relations. Make sure that the code should be properly tested. dept INT Name VARCHAR4514 LE VARAR:45) Indies employee

Please Solve Fast a. Consider the following relations. Make sure that thePlease Solve Fast

a. Consider the following relations. Make sure that the code should be properly tested. dept INT Name VARCHAR4514 LE VARAR:45) Indies employee GINT are VARCHAR(45) Address VARCHAR(45) Kemal VARCHAR45) Phone VARCHAR45) del INT sayINT Indexes O I have provided you database script file with the name of emp.se! Please set up the db in mySQL I have provided you the code HibernateQueryTest.zip. Please write down the entity classes of these relations and setup configuration with db. The db name will be emp. Now write down the following bal queries. a. Write down the bal query to find the minimum and maximum salary of all the dept whose dame are 'Finance and Marketing'. b. Write down the hal query to list the employees whose name is 8 characters in length and whose fifth character is 'A'. c. Write down the hal query to list the employees whose salary is greatert han the averag salary of all the employees

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!