SQL (Using attached relations if applicable) leach 3 marks, total 39: Translate all of the following queries into SQL statements. To get full marks, your answer must run with oracle 8 or above on the server. 1. Get IDEmployee names who have letter m in their surnames 2. Get a list of all different locations in the Location column of Project table 3. Add a new employee to the Employee table 4. Give details of projects worked by Townsend 5. Get all the project locations joined by Cage 6. Delete project "Cape Point" from the table Project" (you do not need to take care of table Job for this question ) 7. Add a constraint to the column surname in table employee that when a new employee is addedthere is information for the last name of the new employee. 8. How many employees join the company between 1998, January and 2000 December 9. Get the projects both Cage and Goreessem joined 10. Get project name whose budget is less than Project "Broederstroom" 11. Find the project which all employees join 12. Change the length of project name column in Project table from 25 to 40 13. Write a left-outer join sql statement and a right-outer join statement to join the information based on Employee and Job tables sorted by ID. (3 marks)

What are the three parts to physical security standards for various types of army equipment and the risk level

For this assignment you have to write a c program that will take an infix expression as input and display the postfix expression of the input. after converting to the postfix expression, the program should evaluate the expression from the postfix and display the result. what should you submit? write all the code in a single file and upload the .c file. compliance with rules: ucf golden rules apply towards this assignment and submission. assignment rules mentioned in syllabus, are also applied in this submission. the ta and instructor can call any students for explaining any part of the code in order to better assess your authorship and for further clarification if needed. problem: we as humans write math expression in infix notation, e.g. 5 + 2 (the operators are written in-between the operands). in computer's language, however, it is preferred to have the operators on the right side of the operands, ie. 5 2 +. for more complex expressions that include parenthesis and multiple operators, a compiler has to convert the expression into postfix first and then evaluate the resulting postfix write a program that takes an "infix" expression as input, uses stacks to convert it into postfix expression, and finally evaluates it. it must support the following operations: + - / * ^ % ( example infix expression: (7-3)/(2+2) postfix expression: 7 3 2 2 result: rubric: 1) if code does not compile in eustis server: 0. 2) checking the balance of the parenthesis: 2 points 3) incorrect postfix expression per test case: -2 points 4) correct postfix but incorrect evaluation per test case: -i points 5) handling single digit inputs: maximum 11 points 6) handling two-digit inputs: 100 percent (if pass all test cases)

Kirk found a local community college with a two-year program and he is comparing the cost with that of an out-of-state two-year school. what is the expected total cost for one year at the local community college if kirk lives at home? what is the expected total cost for one year at the out-of-state school if kirk lives on campus?