the COMPANY database which you have implemented in the class and make the necessary modification to...

Transcribed Image Text:

the COMPANY database which you have implemented in the class and make the necessary modification to it according to the following hypotheses: H1) suppose that you are a new employee to this company and you are going to be a manager. A new department is waiting for you that need your leadership. Use your own identification for this purpose. H2) your new department, of course, requires new employees and for the moment you are limited only to 3 employees. Yourself and your new employees have certainly some dependents which the company provide allowances for them. H3) your department must work on some new projects H4) after one year of hard work, you find that one of your employees is excellent and you decided to increase his salary by 5% in recognition of his contribution to your department. After a while one of your employees wants to leave the company for personal matters and you have to replace him with another one. Note that if the data is not specified you have to come up with the data and use it to implement the hypothesis. Your task is to implement all the above hypotheses H1 to H4 in the database COMPANY. Assessment Reporting To report on the implementation of the above hypotheses: you have to show for every hypothesis two types of SQL statements. a) First type of SQL statements: SQL statements that implement the hypotheses. b) Second type of SQL statements: SQL statements that show evidence that you have implemented the hypotheses. Screen shot must be shown that shows the SQL statement and the output. the COMPANY database which you have implemented in the class and make the necessary modification to it according to the following hypotheses: H1) suppose that you are a new employee to this company and you are going to be a manager. A new department is waiting for you that need your leadership. Use your own identification for this purpose. H2) your new department, of course, requires new employees and for the moment you are limited only to 3 employees. Yourself and your new employees have certainly some dependents which the company provide allowances for them. H3) your department must work on some new projects H4) after one year of hard work, you find that one of your employees is excellent and you decided to increase his salary by 5% in recognition of his contribution to your department. After a while one of your employees wants to leave the company for personal matters and you have to replace him with another one. Note that if the data is not specified you have to come up with the data and use it to implement the hypothesis. Your task is to implement all the above hypotheses H1 to H4 in the database COMPANY. Assessment Reporting To report on the implementation of the above hypotheses: you have to show for every hypothesis two types of SQL statements. a) First type of SQL statements: SQL statements that implement the hypotheses. b) Second type of SQL statements: SQL statements that show evidence that you have implemented the hypotheses. Screen shot must be shown that shows the SQL statement and the output.

Answer rating: 100% (QA)

Implementing the hypotheses H1 to H4 in a COMPANY database would typically require creating new records updating existing records and possibly querying the database for evidence of the changes made Be... View the full answer