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 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
Get step-by-step solutions from verified subject matter experts
